1 Reply Latest reply on Sep 23, 2018 8:14 AM by nikher verma

    Calculation greater than 0 and less than equal to 0 result issue

    Manveen Dharni

      I am having trouble wrapping my head around this issue I am facing.

       

      I have a calculation that does a LOD (FIXED). See Below:

       

      Screen Shot 2018-09-21 at 10.29.58 AM.png

      Both calculations are FIXED on the same only thing different is that in the IF statement its either > 0 or <=0.

       

      The results I am getting is what throwing me off. See Below:

      Screen Shot 2018-09-21 at 10.31.17 AM.png

       

      The high is working as supposed to but the low is giving a asterisk.

       

      Any ideas what that would happen and how to get around to get the correct value? I am expecting 13, 5, 6, 6, etc..... in place of the asterisk. I cannot attach the workbook, but I will try to dummy it up and post it. However, if anyone has experienced this before, let me know.

       

      Any help would be greatly appreciated.

       

      MD

        • 1. Re: Calculation greater than 0 and less than equal to 0 result issue
          nikher verma

          Hi Manveen Dharni ,

           

          * means the result is having multiple values . Try conditioning it as

           

          IF (Condition Statement < 1) THEN 1 ELSE 0 END

           

          In order to check whether your condition statement is working fine or not please create a calculated field and check whether you are getting desired result or not .

           

          And yes ,please attach twbx file in case this will not work .

           

           

          -Nikher Verma

          Please mark it right and helpful if this serves your purpose so that others can also get benefited & also to close the thread.