Skip to main content
Solved

How to calculate the Variation % of two calculated items

  • October 18, 2023
  • 1 reply
  • 143 views

Forum|alt.badge.img+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

 

Best answer by Benoit

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,

1 reply

Benoit
Community Manager
Forum|alt.badge.img+15
  • Community Manager
  • Answer
  • October 24, 2023

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,