Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
Could anyone please help me with an advice on how to calculate the cumulative sum based on the following formula:
Value3 = Value1(t0) - Value1(t-1)/ Value2
Having the following Test Data i should get the results:
AsOfPeriod Value3
12.2022 36,08%
01.2022 -233,91%
02.2022 132,40%
and so on..
i currently use An AsOfTable in order to calculate Value1 and Value2, as these should be also cumulative sumed.
My problem is that i don't know how can i jump to december, when i have to calculate the value for january.
Could anyone please help me with an idea? OH, yes... the Above() doesn't help much, as i need this calculated in a line chart.
Will be really grateful if anyone can helpl me with any information. 🙂
@americanetsMD Can you please attach the QVF that you want to test and explain each one of your issues, so we will see!
Hi @Anil_Babu_Samineni - Thank you for your support. I have found the way to get the right values by using the AsOfMonth in combination with YearDiff and MonthDiff...
sum(Value1) - sum({<MonatDiff -= {0}>} Value1)