July 7, 200223 yr Just need to do a simple calculation but I never d calculation so i'm not sure how to write it out. I need: If "FieldA" is Greater than "FieldB" show "FieldA" Else Show "FieldB" i mean basically thats it I just can't get the calculation to read. do I use = instead of Show ?? I'm just not entirely sure. Thanks Dudes.
July 7, 200223 yr If(FieldA > FieldB, FieldA, FieldB) It reads: If FieldA is greather than FieldB then FieldA if not FieldB. A couple of thoughts: can FieldA = FieldB and make sure you match the calculation result with the data (the options are text, number, date, time or container. This is done in the calculation screen right below where you write your calculation.
Create an account or sign in to comment