Forum Discussion

aminw0u's avatar
aminw0u
Frequent Visitor
8 years ago

Summary Error with IF Statement

Hello,   I'm having issues with an IF and/or SUMX formula. I essentially need the calculation done at every line level & then aggregated. With my first attempt using IF, the results are correct at ...
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

So for SKU Name 87 you have a values of $71 and $88

 

Are these values based on multiple rows that have been aggretated to this single line?

  • aminw0u's avatar
    aminw0u
    Frequent Visitor
    8 years ago

    Thanks. I'm using measures. The Expired PQ & Gross Scrap are measures as well. I had tried calculated columns earlier & got  circular references, so that didn't seem like the way to go.

     

    Is it possible that this is just a bug? I would have expected my formula to work the same as what you have in your file, and I've had several instances of formulas not working when they should have (including while at a DIAD training with Microsoft instructors looking over my shoulder wondering why it wasn't working).