11 Replies Latest reply on Apr 26, 2018 12:45 PM by Deepak Rai

    SUMIFS equivalent to return value in same/unpivoted column

    Lindon Belshe

      Hi! I have a dataset that looks like the following. The goal is to create a calculated field/measure that will return the deviation from the goal (Goal - Act)/Act. However, in the case of Act Sales, I need to return (Frc-Act)/Act for that same group and date. Basically the question is what would be the syntax to match the formula in the second image. I am attaching a sample workbook, though ultimately the measure for "against goal" would be what I'm asking about, and that would be the value that is put in the worksheet (resulting in a table), so I'm not sure how helpful it is beyond what is below.