Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
in my model i have two dates one is used for the master calendar (Date)
and the second is a transaction reference date (ValueDate)
i want an expression that ignores Date Field, and calculates by all smaller ValueDate 's from possible Date
i.e when model's data set include year 2018, and user selected April-18, calculation should include Jan-18 to Apr-18
advanced thanks
hi
it should be something like
sum({<Date,ValueDate={"<=$(=max(Date))"}>}Sales)
hi
it should be something like
sum({<Date,ValueDate={"<=$(=max(Date))"}>}Sales)
Thank you Liron!
my final :
sum({$<Date=, ValueDate= {"<=$(vPossibleDates)"} > } Sales)
vPossibleDates=Date(max(ValueDate))