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.
@wonka1234 Updated the workflow to reflect 1 till the first total
How about changing the formula to:
if left([series],2) = 'CM' || [series] = 'CM'
then 1
else 0
endif
@wonka1234 One way of dong this
@wonka1234 Maybe we can do something like below.
@wonka1234, another way to do this.
Thanks!
@grazitti_sapna @Qiu @binu_acs @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.
@binu_acs thank you for the follow-up.
