=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.
Try this
And in this context is not a function.