Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
You need a dollar sign expansion with function calls inside the set expression, maybe like this:
SUM({<DSS_DATE.IS_WEEKDAY={'$(=true())'} >} DSS_INVENTORY.OUT_OF_STK_STATE)
Stefan
Hi uweh,
what about this:
SUM( if(DSS_DATE.IS_WEEKDAY, DSS_INVENTORY.OUT_OF_STK_STATE, 0))
Regards, Roland
Agree with Roland that it is smarter without set analysis:
sum(DSS_INVENTORY.OUT_OF_STK_STATE * fabs(DSS_DATE.IS_WEEKDAY))
Regards,
Michael