I have a formula in a query that is based on the results of two other formulas. These formulas produce a cumulative result of key figures and work fine, however it appears that I cannot have a formula variable work off these cumulative results as it always works on the base stored key figure results of each. I am wondering if there is a workaround or another approach to use to create this data for my query\report. The type of formula is a YTD percentage where I want to take the total cum values of the other key figures at that date (fiscal year\period) and calculate this result.
Any help or guidance is appreciated.