Conditional Total
Hello everyone. I am trying to calculate a conditional total in report footer.
[IIf(Sum(IIf([Table.AccID] =="AG0",[Table.Amount], 0),Data1) > 0,Abs(Sum(IIf([Table.AccID] == "AG0",[Table.Amount] ,0),Data1)),"")]
I am doing the above thing.
I am getting error - Sum does not exist in the current context.
This used to work in fr3.
Can anyone help please.
[IIf(Sum(IIf([Table.AccID] =="AG0",[Table.Amount], 0),Data1) > 0,Abs(Sum(IIf([Table.AccID] == "AG0",[Table.Amount] ,0),Data1)),"")]
I am doing the above thing.
I am getting error - Sum does not exist in the current context.
This used to work in fr3.
Can anyone help please.