4 Replies Latest reply on Nov 13, 2018 2:46 PM by Michael Ye

    A really simple calculation field doesn't work

    Penn Wang

      Hi All,


      This could be a really simple question. I have a calculation field to divide two figures out of two other calculations.


      The formula is

      [Number of Aircraft Incurring In-flight Delay]/[Number of Records]


      And as you can see in tool tip, the [Number of Aircraft Incurring In-flight Delay] is 1, and [Number of Records] is 4, so the outcome should be 25%. However, the outcome is 100%.



      All filters are applied to all worksheets. Is there anything that I did wrong?


      Thank you!