How to get difference between data for two dates
Hi:
I have a question as to how to get the difference in the amounts for two dates in Answers and Dashboard.
This is the scenario. I have two date prompts and three columns. The first column should be the sum of the amounts for the first date prompt. The second column should be the sum of the amounts for the second date prompt. And the third column is the difference between the first two columns.
Basically I am trying to do something similar to a sum function of two rows but trying to get the difference between the two rows. Any help in trying to resolve this would be appreciated.