Hi -
I have a total field on my report design. I need to enter a logic on its visibility.
I want to have an Iff statement or Swtich statement to decide if I want to Sum the ActualAmount value in Total or not Sum it depending on the paycycleID.
something like this.
IF (Paycycleid == UNION)
{
=SUM(Fields!ActualAmount.Value) (This should be displayed in Totals Column)
}
OR
IF(Paycycleid ==MGMT)
{
=(Fields!ActualAmount.Value) (Then don't Sum it just display the Actual Amount)
}
*This line of code in my expression doesnot work- I was testing this for a start*
Switch(Fields!PayCycleId.Value = "UNION",Sum(Fields!ActualAmount.Value))
Can anyone please help me write this logic in an Expression (Visual Studio 2013)
Thanks
*This post is locked for comments
I have the same question (0)
