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

    Pass or Fail Based on Total

    Elizabeth Viso



      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!