Skip to main content

Hello,

I have used the LQ calculated item to create a table but the amount displayed in April 2023 LQ is the amount of jan 23 actual.  Can you help me ? 
Thanks 

 

Hello !

 

Can you share how you condigured your Calculated Item ? 

Also, what value would you expect if not the last quarter from the actuals ?

 

Thanks


I added a calculated item and selected “last quarter” . It has created the formula below.
Last quarter from actuals should to the sum of jan 23, feb 23 and march 23.
Currently it only retrieves March 23 value.

.


Hey, 

 

The aim of Last quarter is to take the value you had in the month, 1 quarter before, so not for the full quarter.

To get the full quarter, you can use the cumulate selector you have here available, cumulate over month and reset it every quarter. I think this would do the trick.

If yes, could you share the setup here via a screenshot ?

 

Thanks


I found a solution i have created a quarter hierarchy linked to the month and the year :)

Thanks


Reply