Solved

How to calculate the Variation % of two calculated items

  • 18 October 2023
  • 1 reply
  • 95 views

Userlevel 2
Badge +5

Hello,

In the table below i would like to to calculate the Variation % between YTD actual and YTD RF which are 2 calculated items ? 

Thanks for your help

 

icon

Best answer by Benoit 24 October 2023, 14:54

View original

1 reply

Userlevel 6
Badge +12

Hi Cedric,

Since calculated items are not stored like data in blocks are, they can’t be used as sources for a higher level calculation; they’re ad hoc calculations run on your views.

The workaround would be to create real metrics recreating these items. And then to do a comparison.

Hope this helps.

Best,

Reply