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

    A really simple calculation field doesn't work

    Penn Wang
    Penn Wang Nov 13, 2018 2:16 PM

      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%.

      screenshot.PNG

       

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

       

      Thank you!