Percent calculation

Hi,

 

I'm trying to calculate the following:

 

if field a< 20% of field b then 1 else 0

 

How do I approach this?  Please help.

 

Thanks

Best Answer

  • Hi @Pilla ,

     

    You can try below calculation:

    Screenshot_213.png

    Screenshot_214.png

     

    If your 20% is fixed, you can add a separate line item without a time dimension & used in the calculation.

     

    Hope this helps

    Thanks

    Akhtar

Answers

  • I would create a line item that calculates the percentage first - I'll just call it Percent here. Once that is ready, the formula for your other line item would be: IF Percent < 0.2 THEN 1 ELSE 0.

  • Thank you Lauren and Akhtar for your quick and helpful response. They worked!!