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.

Leave a Comment