Acumatica Report designer IF,AND, SUM formula

76 Views Asked by At

=IIf( And(Sum($Basic_Salary) > 10000, Sum($Basic_Salary) < 80000), Sum($Basic_Salary) * 0.04 / 2, IIf(Sum($Basic_Salary) >= 80000, 3200 / 2, 400 / 2) )

enter image description here Im having trouble about this formula, thanks

I try to debug this formula, but I couldn't find the reason why im having the same issue.

1

There are 1 best solutions below

0
On

Try this

=IIf( Sum($Basic_Salary) > 10000 AND Sum($Basic_Salary) < 80000, Sum($Basic_Salary) * 0.04 / 2, IIf(Sum($Basic_Salary) >= 80000, 3200 / 2, 400 / 2) )

And in this context is not a function.