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
May be interplace the logic for =< to <=, Try this?
SUM({<SITUATION={"<=$(=Date#(SITUATION))"}>}PRODUCTTION_VOLUME_TND)
hello anil , i interplace the logic but always the same problem
What format you have for SITUATION? And what logic you need to apply here. Because Date#(SITUATION) returns only Dates not the logic. May be you need some setup like Max() and Min() over Date#()..
can i use this express
SUM({<DATE#(SITUATION)={"<=$(=Date#(SITUATION))"}>}PRODUCTTION_VOLUME_TND) ??????????
i need to sum all sales before selection situation (DATE) : 2017-10 for example
can i use this express
SUM({<DATE#(SITUATION)={"<=$(=Date#(SITUATION))"}>}PRODUCTTION_VOLUME_TND) ??????????
NO, You can't
souad ouertani wrote:
i need to sum all sales before selection situation (DATE) : 2017-10 for example
SUM({<SITUATION={"<=$(=Date#(Max(SITUATION)))"}>}PRODUCTTION_VOLUME_TND)
i tried this expression but not works , i know the problem with situation because it concidere the situation as String and not Date
First, You may work with Date Formats using? Can you explain the Date format?
mm-yyyy