Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have two fields YearMonth and Month .If I select Month previous year value is showing correctly and when I select YearMonth the value is not showing for prev year value.
My expression : =Sum({<Year = {'$(=Max(Year)-1)'}>} Sales)
I wanted both fields to work correctly for expression
.
Thank you
Try this.
Sum({<Year = {'$(=Max(Year)-1)'},YearMonth=>} Sales)
Regards,
Kaushik Solanki
Thanks for @kaushiknsolanki quick reply.
If I use this expression, the YearMonth Selection is not working.
Sum({<Year = {'$(=Max(Year)-1)'},YearMonth=>} Sales)
try to exclude selection of YearMonth & Month
=sum({<YearMonth,Month,Year = {'$(=Max(Year)-1)'}>} Sales)
Hi,
Try this.
Sum({<Year = {'$(=Max(Year)-1)'},YearMonth=,Month=('$(=Maxstring(Month))')>} Sales)
Regards,
Kaushik Solanki
Thank you Solanki for response.
It is applicable for only one selection. There are chances that users select more than one.