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
View original
How to calculate the Variation % of two calculated items
Userlevel 6
+12
- Community Manager
- 154 replies
-
24 October 2023
- Answer
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.