Hi,
I am using the multi row formula tool to select everything before the first "TOTAL". How can I include the first total with my "1"s. Everything below the first "TOTAL" should be 0.
Thank you.
Solved! Go to Solution.
How about changing the formula to:
if left([series],2) = 'CM' || [series] = 'CM'
then 1
else 0
endif
@wonka1234
Maybe we can do something like below.
@grazitti_sapna @Qiu @binuacs @Robin_McIntosh
I prefer if its all 1s upt o the Total.
null rows would be 0.
You guys have done 0 till 1. I want 1s all the way till the first total.
@binuacs
thank you for the follow-up.