How to make QS to keep rolling over previous calculations

Q&A
,
1

Hey team ! How to replicate this Excel formula on QS??

image
image1241×157 4.5 KB

The idea is to get the last result before the 0 and create a value for May, and with that new result start creating results for the other incoming months. using each value for prev month as the starting point…

Regards.

2

Hi,

Here is all the documentation, you can pick what you need :slight_smile:

Regards
Naveed Ali

1 Like
3

thanks for your reply! Probably will need to do some changes to my data, bc it´s giving me this error

" Nesting of aggregate functions like {{aggregateFunction1}} and {{aggregateFunction2}} is not allowed. "

4

Hi @jimallan,
It’s been awhile since we last heard from you, just checking in to see if you have any remaining questions regarding your original question?

If we do not hear back in the next 3 business days, I’ll mark the solution to close out the topic.

Thank you!

5

At the end, none of the solutions provided did work. We can close this now. Thanks