10 Replies Latest reply: Jan 19, 2018 12:48 PM by Elizabeth Viso RSS

    Pass or Fail Based on Total

    Elizabeth Viso

      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!