Equality of multiple values

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
jconnelly
Posts: 15
Joined: Tue Oct 10, 2017 12:44 pm

Equality of multiple values

Post by jconnelly » Thu Jul 13, 2006 4:07 pm

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

jconnelly
Posts: 15
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Equality of multiple values

Post by jconnelly » Thu Jul 13, 2006 4:26 pm

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.__

Post Reply