3 Replies Latest reply on Sep 4, 2018 9:15 AM by Deepak Rai

    Subtract values from different measures and different dates

    Damien Azzopardi



      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!