YTD Calculations Wrong when Showing Values as %

Question

Hello Community,

I am struggling with YTD summaries for %-values. In image 1 I have lines for Revenue and Costs and then I have added metric “Costs” for a second time and I am showing the value as % of Revenue.

When I add YTD calculations (Image 2), I have an issue that also the “% of Revenue (Costs)” seems to be cumulating when in fact it should be always calculated as Costs/Revenue.
This means that for February YTD (ACT) shows -2.20 % (= -1.30 % + -0.90 %) instead of the calculated values, which should be -1.11 % (= -4 664 / 419 306).

Is it possible to keep the YTD calculations for other metrics, but use a “formula”-calculation for the %-metrics?

In case it is any help, here is also a image of how I have pivoted the data.

Benoit · Accepted Answer

Hi,I think you asked the right question about the cause, this happens because you’re making a Show value as on your calculated items and the results are the ones of the calculated items.As of now, we can’t decide / force a calculated item to not run on a metric (Show value AS are metrics but shown differently).If you want this to work, you’ll have to create a metric to replace your show value as.Hope this helps.Best,

Sharon Conroy · Answer

Hi ​@Lehtohen, since your original post we have delivered a feature which allow you to reorder calculations in Pigment - we thought you might be interested in it :)Thanks,Sharon

YTD Calculations Wrong when Showing Values as %

2 replies

Ask your question here!

Ask your question here!

Not finding what you're looking for?

Sign up

Single Sign-On Need help?

Log into the Pigment Community

Single Sign-On Need help?

Scanning file for viruses.

This file cannot be downloaded