Formula Question- Variance between two dates selected

[megan_deboer]

Hello:

I would like to be able to select two dates in a line graph and have a table calculate the difference between the two. Is this possible? I included a screenshot to help.

Thank you,

Megan

[Channa]

yes

write two set expressions

=Sum({$<date={"max(date)"}>} Budget) - Sum({$<date={"min(date)"}>} Budget)

it will do

try

[megan_deboer]

Thanks Channa, Is the 'budget' in the column supposed to be the values I'm using or keep it as 'budget'?

[megan_deboer]

Additional questions for you sorry, I'm new to set expressions. 

I'm setting two separate set expressions or one? I'm just a little confused. I appreciate the help!

[Channa]

if you like to see only difference in table only one expression which is difference

if you like to see 3 columns Minimum from select date , max from select date and difference use 3 expressions

Mindate:= Sum({$<date={"min(date)"}>} Budget)

max date:=Sum({$<date={"max(date)"}>} Budget)

difference :=Sum({$<date={"max(date)"}>} Budget) - Sum({$<date={"min(date)"}>} Budget)

[megan_deboer]

Hi Channa:

thanks for the help, the formula is stating 'ok' at the bottom however, nothing is displaying.  I attached a screenshot. Any ideas? 

Again, I really appreciate your help.

Best, 

Megan