set analysis issue

[souadouert]

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

[Anil_Babu_Samineni]

May be interplace the logic for =< to <=, Try this?

SUM({<SITUATION={"<=$(=Date#(SITUATION))"}>}PRODUCTTION_VOLUME_TND)

[souadouert]

hello anil , i interplace the logic but always the same problem

[Anil_Babu_Samineni]

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#()..

[souadouert]

can i use this express

SUM({<DATE#(SITUATION)={"<=$(=Date#(SITUATION))"}>}PRODUCTTION_VOLUME_TND) ??????????

[souadouert]

i need to sum all sales before selection situation (DATE) : 2017-10 for example

[Anil_Babu_Samineni]

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)

[souadouert]

i tried this expression but not works , i know the problem with situation because it concidere the situation as String and not Date

[Anil_Babu_Samineni]

First, You may work with Date Formats using? Can you explain the Date format?

[souadouert]

mm-yyyy