
1. Re: Calculation Field: Variance for each Quarter
Norbert Maijoor Sep 28, 2017 12:16 AM (in response to gwyn peh)Hi Gwyn,
Find my approach as reference below and stored in attached workbook version 10.1 located in the original thread
e.g. Profit
1. 2012 K1 Profit: if year([Order Date])=2012 and [Order Date (Quarters)]=1 then [Profit] END
2. 2012 K2 Profit: if year([Order Date])=2012 and [Order Date (Quarters)]=2 then [Profit] END
3. 2013 K1 Profit: if year([Order Date])=2013 and [Order Date (Quarters)]=1 then [Profit] END
4. 2013 K2 Profit: if year([Order Date])=2013 and [Order Date (Quarters)]=2 then [Profit] END
5. delta Profit K1: sum([2013 K1 Profit ])sum([2012 K1 Profit])
6. delta Profit K2: sum([2013 K2 Profit ])sum([2012 K2 Profit])
7. delta Profit K1 %: (sum([2013 K1 Profit ])sum([2012 K1 Profit]))/sum([2012 K1 Profit])
7. delta Profit K2 %: (sum([2013 K2 Profit ])sum([2012 K2 Profit]))/sum([2012 K2 Profit])
Regards,
Norbert

delta profit_nalmai.twbx 7.4 MB


2. Re: Calculation Field: Variance for each Quarter
Shinichiro Murakami Sep 28, 2017 4:40 PM (in response to gwyn peh)