Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i used this expression:
SUM({<SITUATION={"=<$(=Date#(SITUATION))"}>}PRODUCTTION_VOLUME_TND)
always it return 0 , but when i change the expression
SUM({<SITUATION={"=$(=Date#(SITUATION))"}>}PRODUCTTION_VOLUME_TND)
it works correctly but i need to sum all productio_volume_tnd when situation <= $situation
Try this?
SUM({<SITUATION={"<=$(=Max(SITUATION))"}>}PRODUCTTION_VOLUME_TND)
OR
SUM({<SITUATION={"<=$(=Date(Max(SITUATION), 'MM-YYYY'))"}>}PRODUCTTION_VOLUME_TND)
Is SITUTATION read as a date field from the script? If not, I would suggest to make sure that it is read as date like this
Date(MonthStart(Date#(SITUATION, 'MM-YYYY')), 'MM-YYYY') as SITUATION
One you have this, you can try this
Sum({<SITUATION = {"<=$(=Date(Max(SITUATION), 'MM-YYYY'))"}>} PRODUCTTION_VOLUME_TND)
Make sure < is before =
<= Right
=< Wrong