2 Replies Latest reply on Aug 20, 2018 7:50 AM by shaheen.haque.1

# YoY calculation of running total value.

Hello,

I am struggling with a table calculation. I need to create a Year on Year compassion and my data is on daily level for two years. In the attached workbook you can see that i have a calculated field(Total Value per thousand ) whose calculation is based on last value of "Total Member" and the running sum of "Total value". So basically i need to have YoY of the field "Total Value per thousand". For instance: if the date range is till 1/5/2018 then i should get YOY based on value 1.25 and 2.73 as per my sample data. Hope i am clear here.

• ###### 1. Re: YoY calculation of running total value.

Hi, Shaheen

It seems you already get the the correct calculation, and you just want to hide the rows and only keep the last for each year. If this is correct, please find my solution attached as well as below screenshot for your reference.

Hope this helps

ZZ

• ###### 2. Re: YoY calculation of running total value.

No i think i was not clear enough. I need another YOY calculation for the data you kept. For 2018 the total value per thousand is 2.73 and for 2017 it is 1.25, so my YOY calculation should be ( (2.73-1.25)/1.25 ) = 118.4%. I am not able to get this value