Hi
I have a requirement to calculate the percentage from the below table
for each row i need to calculate % like below
2820/3058*100 = 92.3%
I did a LOD calculation to fix the grant total number for each row to be the same so that I can calculate the %, but instead of total coming as 3058 I am getting 4343
so my percentage calculation is wrong
{ FIXED [Plant MFG] : COUNTD([CUSTOMER_LOT])}
please let me know what is wrong with my above LOD function .is there any way to achieve this result?
Make sure you aren't excluding any [Error no] associated with ASE-CL. If you're indeed excluding and want to keep it that way, you can write your LOD as SUM({Exclude [Error No]: COUNTD(Customer_LOT)})