Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
how to use Greater than variable in set analysis??was it fine??
=Sum({$< Year = {$(#vYear)}, Quarter = {$(#vQuarter)} , Month = {>=$(#vMonth)}>} sales)
thanks
hi
try this
=Sum({$< Year = {$(#vYear)}, Quarter = {">=$(#vQuarter)} , Month = {<=$(#vMonth)}>} sales)
What you want to achieve end result?
Hi Manish,
I want to achieve QTD sales information.
=SUM({<Month = , Quarter =, Week = , Year= {'$(=max(Year))'}, Date = {">=$(=Date(QuarterStart(Max(Date))))<=$(=Date(QuarterEnd(Max(Date))))"}>}Sales)