Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Difference between dates in set analysis

Hi!

I'm trying to get a sum according to a datefield that decides the activationdate of the invoices to be summarized. I'v got this form a life saver on this forum but it does not work. Any idéas? Or workarounds?

=sum({<InvoiceActivationDate={'>=$(=Date(max(pay_date)-21))<=$(=Date(max(pay_date)-14))'>} OriginalPrice)'

Thanks in advance!

//A.



10 Replies
Not applicable
Author

Thank you so so much!

The reson why i didn't work was the "}" at the end... stupid of me not to see it.

Thanks a lot!!

//A.