13 Replies Latest reply on Mar 28, 2018 5:15 AM by pallavi.gupta.5

# How to Convert Agg calculated field to SUM(calculated field)

Hi,

How to Convert Agg calculated field to SUM(calculated field)? Urgent please help ?

• ###### 1. Re: How to Convert Agg calculated field to SUM(calculated field)

Pallavi,

What's your calculation?

• ###### 2. Re: How to Convert Agg calculated field to SUM(calculated field)

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)

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)

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)

I need your .twbx file to look into it.

• ###### 6. Re: How to Convert Agg calculated field to SUM(calculated field)

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)

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 !!

• ###### 8. Re: How to Convert Agg calculated field to SUM(calculated field)

Pallavi,

Please upload .twbx file not .twb.

• ###### 9. Re: How to Convert Agg calculated field to SUM(calculated field)

Here is twbx file

• ###### 10. Re: How to Convert Agg calculated field to SUM(calculated field)

Hi Pallavi,

Thanks for the file. Is this what you want?

1 of 1 people found this helpful
• ###### 11. Re: How to Convert Agg calculated field to SUM(calculated field)

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)

So Pallavi here is the actual answer. Just modify your formula.

~Tushar

2 of 2 people found this helpful
• ###### 13. Re: How to Convert Agg calculated field to SUM(calculated field)

Thank you soo much !