Equality of multiple values
Equality of multiple values
I have a report that totals some numbers in a group footer (let^s say A,B,C,D,E) and in that footer I need to add a balanced indicator to show if the totals balance. Below is the calcualted field I tried that verifies ok but doesn^t do what I expect. ____A = 100__B = 10__C = 110__D = 110__E = 100____RecordBalances: IIF((A+B) = C = D = (E+B),.T.,.F.)____Without using a long, nested immediate IF, is there a way to check that multiple fields are equal like I tried above?____Thanks,__Jill
=> RE: Equality of multiple values
I think I may have found a solution but need to test further.____RecordBalances: IIF( (A+B)=C AND C=D AND D=(E+B)____Not pretty but logically may work. If anyone has a better solution, I am open.__