Skip to main content

Hi All,

 

I want to create a calculated filed to represent total of H1 Ach% field minus 15% of the total in case of any product H1 Ach % less than 20%, This total products achievement% field for all products per each user as per the screenshot below,

Create Total with Calculated field

Please find attached TWB.

 

Thanks in advance!

 

Regards,

Mostafa

8 answers
  1. Jan 6, 2020, 12:47 PM

    Hi Mostafa Anwar,

     

    Try this below attached workbook and let me know if this is what you looking for or not.

    Hi Mostafa Anwar, Try this below attached workbook and let me know if this is what you looking for or not.

     

    Thanks,

    Dishant Shah

0/9000