Skip to main content

Hi, 

I'm trying to perform a calculation in a metric that’s part of an iterative calculation. What I want to achieve is to take the value from the last non-blank month in Module A and allocate it to the latest actual month.

I’ve tried using the same formula that’s applied in the I02 FY RF metric, but it’s not giving the desired result here. Interestingly, when I use the same formula in a different metric, it gives the correct value.

I suspect the difference might be because this is an iterative metric and Month is the iterative dimension. Could you please suggest how I can handle this situation?

 

 

Hi ​@Md Saquib 

 

Could you please check a few general thing I can think of?

  • are the metric dimensions the same?
  • is pivoting the same?
  • are the Aggregators in the menu ∑ the same?
  • are the filters the same?
  • have you got any formula errors?
  • refresh the webpage (F5) and check again?

Fingers crossed these could help.

Ask your question here!

Terms & ConditionsCookie settingsAccessibility statement