Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am calculating a percentage:
=Num([Actual Load Percentage]/100,'0%')
Which gives me 54%, now based on that I want to add a column showing PASS or FAIL. So if the percentage is over 30% it passes and if it's under 30% it Fails. I've tried a few ways and it doesn't seem to be working.
Anyone have any suggestions?
Thank you!
My bad, I forgot to add the if(
=If([Actual Load Percentage] > 30, 'Pass', 'Fail')
Can you duplicate the column, and wrap the statement in an IF statement. Basically,
IF(Original Formula >30%, "Pass", "Fail")
should be just this
=[Actual Load Percentage] > 30, 'Pass', 'Fail')
Hey SUnny,
I tried that but it gives me an error.
Hi,
Yup tried that and also not working, getting an error.
Is this in a script or expression? Can you share a screenshot?
I'm doing this as an expression.
screenshot?
Sorry thought I attached it!
My bad, I forgot to add the if(
=If([Actual Load Percentage] > 30, 'Pass', 'Fail')