Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You are missing a closing }... try this:
=Sum({<Date_Actuals ={">=$(=min(Date_Actuals))<=$(=max(Date_Actuals))"}>}Amount)
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