2 Replies Latest reply on Jun 29, 2018 7:46 AM by Damien Azzopardi

    Subtract values from different measures and different dates

    Damien Azzopardi

      Hi,

       

      I am looking for a way to subtract two values from different measures at two different dates.

       

      I would like to get the difference from the LTV 5 DAYS AGO (from the 16th of June) and the CPA (from the 20th of June), and then show just one number ($5.51) to present in a dashboard.

      Screen Shot 2018-06-21 at 5.37.50 PM.png

       

      I have found a way to get the difference by creating the following calculated fields:

      - First Date Value: LOOKUP(([LTV 5 DAYS AGO)]),FIRST())

      - Last Date Value: LOOKUP(([CPA YESTERDAY]),LAST())

      - First - Last: [First Date Value]-[Last Date Value]

       

      Which returns this table:

      Screen Shot 2018-06-21 at 5.45.21 PM.png

       

      I now have the correct number ($5.51) but I would like this number to appear in only one cell so I can show it in a dashboard, like that:

       

      Screen Shot 2018-06-21 at 5.47.55 PM.png

       

      Thanks in advance!