Issue: I need a formula to work one way when its to account 0500 and another way when it isn't.
I tried: 0500 ‘0500’ and “0500”, and the formula is only returning values for the false.
How to I format the expression to return the result for when its True.
= IIf( [GLTran.AccountID]= '0500', ( ([GLTran.CreditAmt] *.5) - ([GLTran.DebitAmt] ) *.5) , ([GLTran.CreditAmt] *.75) - ([GLTran.DebitAmt] ) *.75 )