1 Reply Latest reply on May 12, 2018 1:18 AM by Chris McClellan

    How to subtract yesterday's (CNT) value from today's (CNT) value

    Edward Tarry



      I am simply needing to create a value that subtracts yesterday's value from today's value. I am sure there is a simple calculation to do so, but I can't seem to figure it out. The figures are COUNT figures if that changes anything.


      So for example, if today's value is 15 and yesterday's was 19, the equation would need to solve 15 - 19 = -4


      This is what I have so far, yet when I try to make the calculation output into label format, it shows up blank:


      COUNT([DB Type]) - LOOKUP(COUNT([DB Type]),-1)


      Please let me know if you can help. Thanks in advance!