14 Replies Latest reply on Aug 23, 2018 10:00 AM by Jessica Singer

    Simple calc returns NOTHING, why?

    Jessica Singer

      I need to build a composite score for each student, in each period, so that I can compare the change over time. However, to ensure fidelity I have to exclude those scores for skills that were not tested in each period.

       

      I've tried:

       

      IF ISNULL([Score Pre]) OR ISNULL([Score Post]) THEN NULL

      ELSE [Score Pre]

      END

       

      Which is a variation of a calc I was given in a previous thread. But this returns nothing. I've tried wrapping it in SUM, also nothing.

       

      Help! And thank you.