
1. Re: Add Measure values to itself
Naveen B Aug 20, 2018 5:19 AM (in response to pavan kumar)Hi Pavan,
Check the below snapshot
Changed the calculation little bit like this
find the attached workbook
Hope this helps kindly mark this answer as correct and helpful so that it will help others
BR,
NB

Add Values to itself_v10.2.twbx 21.7 KB


2. Re: Add Measure values to itself
pavan kumar Aug 20, 2018 10:11 PM (in response to Naveen B)Hi Naveen ,
Thank you so much for the reply ,
instead of Amount i need to do this on other measure ie Forecast.
When i am trying to apply same formula on Forecast it is throwing an error.
Could you please review it if possible.
Forecast is aggregated field.
Plz find attached workbook.

3. Re: Add Measure values to itself
pavan kumar Aug 21, 2018 2:23 AM (in response to pavan kumar)Thanks for the support Naveen , finally found the Solution.
This is the formula
IF attr([Term]) = 1 THEN
(IF attr(CONTAINS([Quarter],"Q4")) THEN
(SUM({FIXED [Quarter]:sum(if [Term]=1 then [Amount] END)}))+
(lookup(SUM({FIXED [Quarter]:sum(if [Term]=1 then [Amount] END)}),1)*.1)
ELSE
((SUM({FIXED [Quarter]:sum(if [Term]=1 then [Amount] END)}))) +
((lookup(SUM({FIXED [Quarter]:sum(if [Term]=1 then [Amount] END)}),1)*.5)) END)*.5+
(IF attr(CONTAINS([Quarter],"Q4")) THEN
(SUM({FIXED [Quarter]:sum(if [Term]=2 then [Amount] END)}))+
(lookup(SUM({FIXED [Quarter]:sum(if [Term]=2 then [Amount] END)}),1)*.1)
ELSE
((SUM({FIXED [Quarter]:sum(if [Term]=2 then [Amount] END)}))) +
((lookup(SUM({FIXED [Quarter]:sum(if [Term]=2 then [Amount] END)}),1)*.5)) END)
ELSEIF ATTR([Term]) = 2 THEN
(IF attr(CONTAINS([Quarter],"Q4")) THEN
(SUM({FIXED [Quarter]:sum(if [Term]=1 then [Amount] END)}))+
(lookup(SUM({FIXED [Quarter]:sum(if [Term]=1 then [Amount] END)}),1)*.1)
ELSE
((SUM({FIXED [Quarter]:sum(if [Term]=1 then [Amount] END)}))) +
((lookup(SUM({FIXED [Quarter]:sum(if [Term]=1 then [Amount] END)}),1)*.5)) END)*.5*3+
(IF attr(CONTAINS([Quarter],"Q4")) THEN
(SUM({FIXED [Quarter]:sum(if [Term]=2 then [Amount] END)}))+
(lookup(SUM({FIXED [Quarter]:sum(if [Term]=2 then [Amount] END)}),1)*.1)
ELSE
((SUM({FIXED [Quarter]:sum(if [Term]=2 then [Amount] END)}))) +
((lookup(SUM({FIXED [Quarter]:sum(if [Term]=2 then [Amount] END)}),1))) END)*0
END