2 Replies Latest reply on Oct 16, 2012 2:21 AM by Bart Valgaerts

    calculate previous date value

    Bart Valgaerts

      Hi everyone,


      i'm building a new TB dashboard. Dashboard is just a table with some calculations.


      What I need to show, is a sales number of the current date, but also the sales number of the previous date.


      Does anybody know how the show the value of the previous date as well? I can calculate the previous day, based on the current date, but I can't seem to show the sales value of the previous date.


      I'm calculating my previous date useing this calculation for [Previous Day]: DATEADD('day',-1,[Date])


      And my previous sales value: IF([Date] = [Previous Day]) THEN ([Effective occupation actual]/[Approved licenses])*100 ELSE 0 END


      But the value of the previous sales value keeps giving me 0.


      The table in which I show my data, is filtered on todays date.


      Any suggestions?