
1. Re: some one please help me how this formula works SUM({FIXED [SubCategory]:SUM([Sales])}) / SUM({(SUM([Sales]))})
Ankit Bansal Jul 26, 2018 1:51 AM (in response to anjali b)Anjali,
Curly braces we use to do LOD calculations. With LOD calculations you can aggregate the measures at the level other than your viz. Check the below link :
Let me know if you need more help in understanding.

2. Re: some one please help me how this formula works SUM({FIXED [SubCategory]:SUM([Sales])}) / SUM({(SUM([Sales]))})
Ankit Bansal Jul 26, 2018 1:53 AM (in response to anjali b)If by chance you are from SQL background you can refer to the below document:

3. Re: some one please help me how this formula works SUM({FIXED [SubCategory]:SUM([Sales])}) / SUM({(SUM([Sales]))})
Paulo Dantas Jul 26, 2018 1:55 AM (in response to anjali b)Hello Anjali,
this calculated field is set the dimension from your view to SubCategory to use in the calculation, making the SUM(Sales) of him and after that make the Div calculation to all the sum(sales) from SubCategory in another dimensions.
Are you using more than one dimension in your view?
Can you share the twbx or a image from the dashboard?

4. Re: some one please help me how this formula works SUM({FIXED [SubCategory]:SUM([Sales])}) / SUM({(SUM([Sales]))})
anjali b Jul 26, 2018 3:54 AM (in response to Ankit Bansal)ya but fixed lod expression was 1st part and i am getting error on second pat if i remove the curley braces there i sno lod keyword in second part

5. Re: some one please help me how this formula works SUM({FIXED [SubCategory]:SUM([Sales])}) / SUM({(SUM([Sales]))})
Okechukwu Ossai Jul 26, 2018 5:26 AM (in response to anjali b)Hi Anjali,
Although there is no explicit keyword, the second part is also an LOD . It is a short hand form of saying, 'fix the calculation to the entire dataset'.
{SUM([Sales])} is exactly the same as {FIXED: SUM([Sales])}
What the formula does is to fix the calculation to the entire dataset. In this case, it will sum and return the total of all available sales data.
So, your formula can be rewritten as below. Both will give the same result.
SUM({FIXED [SubCategory]:SUM([Sales])}) / SUM({FIXED: SUM([Sales])})
Hope this helps.
Ossai