
1. Re: How to Convert Agg calculated field to SUM(calculated field)
Tushar More Mar 26, 2018 3:20 AM (in response to pallavi.gupta.5)Pallavi,
What's your calculation?

2. Re: How to Convert Agg calculated field to SUM(calculated field)
pallavi.gupta.5 Mar 26, 2018 3:51 AM (in response to Tushar More)Hi ,
Here i am calculating some future year Turnover with the formula =
Turnover == (IF [Initial year] >= [Year take off input] then ([Share Jump per year]*([Initial year]  [Year take off input]+1)+[Market Share]) ELSE[Market Share ]
END) * SUM([ MArket Size])
Now if i drag and drop my "Turnover" in the table view, it AGG not SUM

3. Re: How to Convert Agg calculated field to SUM(calculated field)
Partha Chowdhury Mar 26, 2018 3:51 AM (in response to pallavi.gupta.5)Hi Pallavi,
If the Calculated field is already aggregated (like SUM,AVG..) then by default when you drag the field to view it will masked as AGG (that you can not aggregate it any more) or change to other aggregation function.
If you want to aggregate on aggregate field ..then go for LOD expression
Thanks,
Partha

4. Re: How to Convert Agg calculated field to SUM(calculated field)
pallavi.gupta.5 Mar 26, 2018 3:56 AM (in response to Partha Chowdhury)Thanks,
But in the above formula mentioned , if i remove SUM from the formula..the formula itself gives me error.

5. Re: How to Convert Agg calculated field to SUM(calculated field)
Tushar More Mar 26, 2018 4:32 AM (in response to pallavi.gupta.5)I need your .twbx file to look into it.

6. Re: How to Convert Agg calculated field to SUM(calculated field)
Partha Chowdhury Mar 26, 2018 5:31 AM (in response to pallavi.gupta.5)Create a LOD expression using the Turnover calculated field as below ..
{include [dimension],.. : SUM(Turnover)}
*choose the dimension as per your viz level of detail
And then use the LOD expression in your View.

7. Re: How to Convert Agg calculated field to SUM(calculated field)
pallavi.gupta.5 Mar 27, 2018 11:27 PM (in response to Partha Chowdhury)Hi all,
I am attaching a sample workbook . I need a solution to how to get SUM ( company turnover 2018 ) instead of AGG( company turnover 2018) without changing existing formulae. Please help !!

Sample workbook.twb 35.8 KB


8. Re: How to Convert Agg calculated field to SUM(calculated field)
Tushar More Mar 27, 2018 11:31 PM (in response to pallavi.gupta.5)Pallavi,
Please upload .twbx file not .twb.

9. Re: How to Convert Agg calculated field to SUM(calculated field)
pallavi.gupta.5 Mar 28, 2018 1:23 AM (in response to Tushar More)Here is twbx file

Sample workbook.twbx 19.5 KB


10. Re: How to Convert Agg calculated field to SUM(calculated field)
Tushar More Mar 28, 2018 2:12 AM (in response to Tushar More)1 of 1 people found this helpful 
11. Re: How to Convert Agg calculated field to SUM(calculated field)
pallavi.gupta.5 Mar 28, 2018 4:29 AM (in response to Tushar More)Yes Tushar, thats what i am looking for. How did you do that ?

12. Re: How to Convert Agg calculated field to SUM(calculated field)
Tushar More Mar 28, 2018 2:52 AM (in response to Tushar More)2 of 2 people found this helpful 
13. Re: How to Convert Agg calculated field to SUM(calculated field)
pallavi.gupta.5 Mar 28, 2018 5:15 AM (in response to Tushar More)Thank you soo much !