Circuler Reference

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' <= '[Live] Forecast Start Date','[Live - Weekly] Revenue / Seller Final', Previous(week) * '[Live - 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 '[Live] 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%)

Thank you ​@Min Li Bright Point @Stef , 

Yes, it seems the model works, but I prefer not to have the Input metric and instead override the WoW directly in the Revenue / Seller Final metric. 

As shown below, the calculation works only if I input the rates in below yellow boxes, but I would like to avoid using another metric. 

I can give Pigment account access to this app if that helps! I also have one final question, related to the scenario. I can also jump on a call if that is better as well. Please let me know. Thank you

​@Yaejis I created a metric to combine actual WOW and forecast WOW, and enable overriding.

WOW = if(Week.'Start Date'<='10 Forecast Start Date','10 WoW Actual', blank[by:Week,'10 Sales Cate'])

blank[by:Week,'10 Sales Cate'], this part is used to create blank for the future using the same dimensions as '10 WoW Actual'

Not following the Blank part… something like this…?

IF(Week.'Start Date' < '[Live] Forecast Start Date','[Live - Weekly] Revenue / Seller - Stage' + '[Live - Weekly] Revenue / Seller Total'[BY: 'Seller Segment'."Total"],  blank[BY: Week,             )
 

In my table,
‘10 Target metric’ is your metric for calculating Revenue/seller. I used an input metric for dummy data.

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

'10 WoW' is for calculating WoW% for both actual and forecast months. The blank part is for the future WOW%.
'10 WoW' = if(Week.'Start Date'<='10 Forecast Start Date','10 WoW Actual', blank[by:Week,'10 Sales Cate']
'10 WoW Actual' = ('10 Input Metrics'-'10 Input Metrics'[select:Week-1])/'10 Input Metrics'[select:Week-1]

You can replace '10 Input Metrics' with '[Live - Weekly] Revenue / Seller Final'

Ah got it. Thanks!

Seems I can enter in the WoW rate for the forecast weeks, but the Revenue/Seller forecast result does not work due to circulate issue.