The smart way for boolean filter with Set Analysis

[#1]

Is there a smarter way than this?

SUM({<DSS_DATE.IS_WEEKDAY={"-1"}     >} DSS_INVENTORY.OUT_OF_STK_STATE)

Like:

SUM({<DSS_DATE.IS_WEEKDAY={"=true()"}     >} DSS_INVENTORY.OUT_OF_STK_STATE)

[swuehl]

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

[#3]

Hi uweh,

what about this:

SUM( if(DSS_DATE.IS_WEEKDAY, DSS_INVENTORY.OUT_OF_STK_STATE, 0))

Regards, Roland

[Anonymous]

Agree with Roland that it is smarter without set analysis:

sum(DSS_INVENTORY.OUT_OF_STK_STATE * fabs(DSS_DATE.IS_WEEKDAY))

Regards,

Michael