6 Replies Latest reply on Sep 11, 2018 10:51 PM by Zhouyi Zhang

    Profit / loss per sale by item code

    Puja Doona

      I have a simple question which I'm not able to solve for.

       

      Given: I have sales, cost, profit/loss by a bunch of items and I want to calculate either profit / loss by each sale per item ID (the last column). I wanted to use LOD to do that as I think that's the best solution but not able to figure out how to get to it? I tried playing around with it but because profit / loss is an aggregate it does throws an error.

       

      Can someone help?

       

      Thanks