This content has been marked as final.
Show 4 replies

1. Re: calculate % of sum total with base as the first number
Emmanuel Ikehi Sep 19, 2018 5:04 AM (in response to Atishi Goyal)Hi Atish, I have an idea, but attach a sample workbook (.twbx file) so I can try it out.
Emmanuel.

2. Re: calculate % of sum total with base as the first number
Atishi Goyal Sep 19, 2018 6:20 AM (in response to Atishi Goyal)
Book3.twbx 3.7 MB


3. Re: calculate % of sum total with base as the first number
Emmanuel Ikehi Sep 19, 2018 9:35 AM (in response to Atishi Goyal)Hi Atishi,
Find attached the solution. It was more complex than I had imagined. I have used a combination of ISNULL() and PREVIOUS_VALUE() to find the first nonnull value in a row. See the calculated field First NonNull Value in the attached workbook to understand how it works.
I hope this is what you are looking for.
Emmanuel.

Book3.twbx 3.7 MB


4. Re: calculate % of sum total with base as the first number
Atishi Goyal Sep 20, 2018 6:03 AM (in response to Emmanuel Ikehi)Thanks Emmanuel Ikehi