Jul 26, 2017 #1 jlr123 Technical User Joined Feb 24, 2014 Messages 117 Location US need formula to count {myfield}which is "customer number" if {my field} which is a $ value =0.00 see below: count (CustomerNo}if {@YTD}=0.00 Thanks for your assistance.
need formula to count {myfield}which is "customer number" if {my field} which is a $ value =0.00 see below: count (CustomerNo}if {@YTD}=0.00 Thanks for your assistance.
Jul 27, 2017 #2 lbass Technical User Joined Feb 9, 2002 Messages 32,818 Location US Create a formula {@null} by opening and saving a formula without entering anything. Then create a conditional formula{@ytd0}: If {@YTD}=0 then {table.customerNo} else Tonumber({@null}) Then insert a count on {@ytd0}. -LB Upvote 0 Downvote
Create a formula {@null} by opening and saving a formula without entering anything. Then create a conditional formula{@ytd0}: If {@YTD}=0 then {table.customerNo} else Tonumber({@null}) Then insert a count on {@ytd0}. -LB