Multi Row Formula, numbering rows after word

[wonka1234]

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.

[Robin_McIntosh]

How about changing the formula to:

if left([series],2) = 'CM' || [series] = 'CM'

then 1

else 0

endif

[binuacs]

@wonka1234 One way of dong this

[Qiu]

@wonka1234 
Maybe we can do something like below.

[grazitti_sapna]

@wonka1234, another way to do this.

Thanks!

[wonka1234]

@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 · Accepted solution]

@wonka1234 Updated the workflow to reflect 1 till the first total

[Qiu]

@binuacs 
thank you for the follow-up.