Percent calculation

Pilla
Occasional Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Akhtar.shahbaz
Community Boss

Re: Percent calculation

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

View solution in original post

3 REPLIES 3
LaurenF
Group Leader - Employee

Re: Percent calculation

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.

Akhtar.shahbaz
Community Boss

Re: Percent calculation

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

View solution in original post

Pilla
Occasional Contributor

Re: Percent calculation

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