Skip to main content

Hello,

I have one table that has a number of calculated items in them. 

In the order of events: first the YTD value is calculated using cumulate (works fine). Secondly, the index versus budget is calculated (works fine for YTD) and lastly the index versus LY is calculated (that one goes wrong for YTD (only blanks). The strange thing is, is that that ratio versus LY does work fine when calculated over the month, but it shows blanks when calculated over YTD.

Below are snapshots of my calculated items. Can anybody see why the index versus LYTD would return blank values?

Thanks, Bas

 

 

Hi Bas,

Marty here from Pigment Product Support. 

I would encourage you to submit this as Support ticket so that we can take a look at the specific configuration of your table. There may be some conditions in your formulas or some other aspect of your table properties that are causing the Index vs LY property to not populate. 

You can submit a ticket here and we’d be happy to take a closer look for you.

Cheers,
Marty

Reply


Ask your question here!

Terms & ConditionsCookie settings