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
Tagged:
0
Best Answer

Hi @Pilla ,
You can try below calculation:
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
1
Comments

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.
1 
Thank you Lauren and Akhtar for your quick and helpful response. They worked!!1