Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how can i create start and End date variable to use in set analysis
thanks ahead
Hi, this can be done in many different ways based on the model and the needs, one option is to create a vMinDate and vMaxDate variables with this values:
vMinDate -> Min(DateField)
vMaxDate -> Max(DateField)
And used like: Sum({<DateField={">=$(vMinDate)<=$(vMaxDate)"}>} Sales)
Hi, this can be done in many different ways based on the model and the needs, one option is to create a vMinDate and vMaxDate variables with this values:
vMinDate -> Min(DateField)
vMaxDate -> Max(DateField)
And used like: Sum({<DateField={">=$(vMinDate)<=$(vMaxDate)"}>} Sales)
thanks a lot