Using Max and Min functions in set analysis

[Anonymous]

Hi i need to pick max of Date_Actuals from Fact in order to calculate the total Amount  from "Amount".

This below expression is not giving any results :

=Sum({<Date_Actuals ={">=$(=min(Date_Actuals))<= $(=max(Date_Actuals))">}Amount)

Please let me know the correct syntax

Thanks in adavance

[sunny_talwar]

You are missing a closing }... try this:

=Sum({<Date_Actuals ={">=$(=min(Date_Actuals))<=$(=max(Date_Actuals))"}>}Amount)

[dunnalahk123]

Hi Sunny,

Same expression i am trying to use  as below

My point is Q118 should not come as i am taking month greater than 201802 which Q2FY18 , but for me Q118 is coming and data is coming as 0.

Any idea or suggestion please.

Sum({<Month ={">=201802 <=201904"}>}NumValue)

Best Regards,

HK