5 Replies Latest reply on Jul 6, 2018 7:59 AM by Zach Ferris

    If/Then Help

    Zach Ferris

      I have a crosstab sheet that lists Patient ID followed by all Sales Order Numbers associated with that patient and an LOD Calculation that counts the amount of Item IDs per Sales Order. What I want to do is get an average count of "Item Transitions" per patient. Item Transitions would be defined as when a count of IDs changes from one SO to another. So using my LOD function, I imagine an IF/THEN statement is necessary. There is a date field, which makes me think this could be similar to a moving average table calc, right?

       

      IF [Count of Items per SO] in month one =/= [Count of Items per SO] in month two THEN "1" ELSE "0" END

       

      Something like that, but I imagine there will be a tablecalc to look at the previous SO or previous order delivered and look at the difference.

       

      Then, could I just use the "Grand total" in the analytics tab and summarize using Average instead of Total?

       

      I hope this makes sense. There is a very good chance I'm overthinking it. Any help is appreciated.