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.
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
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