1 Reply Latest reply on Sep 12, 2018 10:33 AM by maneesh.gaddam

    Issue in calculating percentage

    Shri Siva

      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?