I am having two problems with the following expression:
If(([CUSTOMERLEDGERENTRY Due Date]<=vToday) AND ((vToday - [CUSTOMERLEDGERENTRY Due Date])<30),sum({<[DETCUSTOMERLEDGERENTRY Posting Date]={"<=$(=max([DETCUSTOMERLEDGERENTRY Posting Date]))"}>}[DETCUSTOMERLEDGERENTRY Amount]))
My situation is this: I have the sum of amount in a straight table for everything below a selected DETCUSTOMERLEDGERENTRY Posting Date. This works fine.
Next to it I have 4 columns, showing the totals with a due date which has not passed, them with less then 30 days overdue, 90 and more then 90. I have used the expression above to solve this (as an example this shows the one between today and less then 30).
My first problem is: I would like to replace the vToday with the selected DETCUSTOMERLEDGERENTRY Posting Date. But this doesn't work as expected.
My second problem is: When I select a DETCUSTOMERLEDGERENTRY Posting Date with the expression as it is now, he only sums the records with DETCUSTOMERLEDGERENTRY Posting Date at that date and not the ones below.
I have been trying to fix this but can't seem to solve it.
If you need more information don't hesitate to ask.