Skip to main content
Solved

Last quarter calculated item not displaying the right amount

  • September 28, 2023
  • 4 replies
  • 121 views

Forum|alt.badge.img+5

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 

 

Best answer by Cedric LJ

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

Thanks

4 replies

Franck C
Employee
Forum|alt.badge.img+4
  • Employee
  • September 28, 2023

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


Forum|alt.badge.img+5
  • Author
  • Master Author
  • September 28, 2023

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.

.


Franck C
Employee
Forum|alt.badge.img+4
  • Employee
  • September 28, 2023

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


Forum|alt.badge.img+5
  • Author
  • Master Author
  • Answer
  • September 29, 2023

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

Thanks