IF (@ISLEV("PRODUCTS",0))if ("RET_QTY_OVW"<> #MISSING) "RET_QTY_OVW";else "RET_QTY_CALC";ENDIF;ENDIF
I've not tested this but you might try something like:
Case When ISLEVEL([Products].currentmember,0) and Not Isempty([Ret_QTY_OVW]) Then
[RET_QTY_CALC]
END
You might need to change [Ret_QTY_OVW] to [Ret_QTY_OVW].currentmember
|