2 Replies Latest reply on Aug 25, 2018 6:22 AM by francesco.fincato.1

    Revenues Calculation

    francesco.fincato.1

      Hi All,

       

      I am trying to calculate the Revenues on a data source which is giving me a headache on how to calculate the Revenues for each of the Item Names only for 1 "Id (deliveries.csv)" for each "Order Number (ID)". This would avoid doubling the final amount of revenues I get:

       

      So far, I have tried a couple of ways but I am always getting Null values out of that, even if it works when filtering for the single order.

       

      This is one option I tried:

       

      IF attr([Id (deliveries.csv)])=attr([Count First Id Deliveries +1 (for Multiple Deliveries)]) then [Orders Revenue (gbp)]

      elseif attr([Count Id Deliveries (for Multiple Deliveries)])<=2 then [Orders Revenue (gbp)]

      END

       

      This works when I take into account a single order, but as long as I pull out all of the orders there are some Null Values showing up and I don't know how to solve that.

       

      Thank you very much in advance for any suggestion you might have.

       

      Regards,

       

      Francesco