Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
here i trying to ignore one field selection in set analysis, but still its taking selection from that field, here is my metrics
Sum({$<Month = {"$(='>=1<='& max(MonthNum))"}, Year = {"$(='>=2011<='& max(Year))"}, YearMonth= ,MonthNum=>}Sales)
above one taking selections from YearMonth and MonthNum fields,
can you please let me know what is wrong this expression
Thanks in advance
Try this:
Sum({$<Month = {"$(='>=1<='& max({1}MonthNum))"}, Year = {"$(='>=2011<='& max(Year))"}, YearMonth= ,MonthNum=>}Sales)
@Gopi_E Perhaps this
Sum({$<Month = {"$(='>=1<='& max({<MonthNum, YearMonth>} MonthNum))"}, Year = {"$(='>=2011<='& max({<MonthNum, YearMonth>} Year))"}, YearMonth= ,MonthNum=>}Sales)
Try this:
Sum({$<Month = {"$(='>=1<='& max({1}MonthNum))"}, Year = {"$(='>=2011<='& max(Year))"}, YearMonth= ,MonthNum=>}Sales)
Hi Arthur_Fong,
Thanks for the reply,
it's working as i expected, thank you
@Gopi_E Perhaps this
Sum({$<Month = {"$(='>=1<='& max({<MonthNum, YearMonth>} MonthNum))"}, Year = {"$(='>=2011<='& max({<MonthNum, YearMonth>} Year))"}, YearMonth= ,MonthNum=>}Sales)