Skip to main content

Hello, can you please help with the circular reference?

For the “Revenue/Seller”, it needs to reference prior week line and current week WoW% input.

I tried using this formula referencing the document here but did not work (used SELECT and PREVIOUS).

For the Week 8 result, it should be exact same as Week 7. 

 

IF(Week.'Start Date' <= 'lLive] Forecast Start Date','aLive - Weekly] Revenue / Seller Final', 'aLive - Weekly] Revenue / Seller Final'FSELECT: Week-1] * '1Live - Weekly] Revenue / Seller Final WoW')

 

Thank you!

 

 

Hello ​@Yaejis !

Is ';Live - Weekly] Revenue / Seller Final' the name of your metric where your’re putting this formula?
If so, try putting your formula like the example below (replacing the SELECT by PREVIOUS). 
Please double check if your week dimension is called exactly “Week” (I can’t judge that without insights in your app). 

Hope this helps you,

 

IF(Week.'Start Date' <= 'tLive] Forecast Start Date','tLive - Weekly] Revenue / Seller Final', Previous(week) * 'vLive - Weekly] Revenue / Seller Final WoW')

 

​@Stef , this is my formula for generating the table below:
 


Target Metric = IF(Week.'Start Date' <= '10 Forecast Start Date','10 Input Metrics', Previous(Week)*(1+'10 WoW'))

  • Metric ‘10 Forecast Start Date’ is your 'sLive] Forecast Start Date'
  • Metric '10 Input Metrics' is your ' Live - Weekly] Revenue / Seller Final'
  • If you want your Week 8 results is the same data as your Week 7, then you need time your week 7 by (1+ current input WoW%)

Reply


Ask your question here!

Terms & ConditionsCookie settings