
1. Re: Calculations
shripal gandhi Mar 10, 2017 1:59 AM (in response to DIVYA TIKKISETTI)1 of 1 people found this helpfulHi Divya,
Please see an example below :
Calculated field
ProfitRatio = SUM([Profit])/SUM([Sales]). Now when you export out the data with calculations, ProfitRatio field will no more be holding any formula.
So, we will not get the required values with exported data.
For addition, subtraction etc. Writing Calculated fields and exporting data works. i.e. Sum(Profit) + Sum(Margin).
Hope this helps

2. Re: Calculations
Allen Gapara Mar 10, 2017 2:00 AM (in response to DIVYA TIKKISETTI)It will be easier, if you post a workbook. Screen shots of what you have and what you expect, would also go a long way.

3. Re: Calculations
DIVYA TIKKISETTI Mar 10, 2017 2:55 AM (in response to shripal gandhi)Hi ,
Thanks Shripal and Allen for the reply.
Apologies..!! cant share the workbook due to confidential issues.
Here are the screenshots.
Previous:actfct is a calculation(SUM([Turnover CY])  SUM([expectFCT]) and is shown in tableau view as AGG(actfct)
Present:Now to avoid calculations and overload,calculations are moved to sematic layer(as columns) . Now those col's are coming as measures and
bought to tableau view,
It is going as SUM(actfct)
How can I get the accurate value of previous AGG(actfct)