Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a if statement
if(NO ='P10'and value >2,'Yes','No')
and then I need to take this variable and use further. if i'm counting yes values its showing right count but when i'm counting both yes no values it is showing wrong value , could you please suggest something
Because, This condition filled with either Yes nor No. You must clear about that where and what you are doing. I am assuming you created one flag for Yes and No field.
For Yes and No below one, This will deserve with accuracy count
Count({<YesNoFlag = {Yes}>}Sales)
Count({<YesNoFlag = {No}>}Sales)
For Yes and No count you can do something like below
Count({<YesNoFlag = {'Yes', 'No'}>}Sales)