How to add expressions to set analysis to show expected values!

[nevilledhamsiri]

Hi!

I have following dimensions!

CLASS_CODE

CR_MONTH

TR_MONTH

ME_CODE

& FOLLOWING EXPRESSIONS

CR_PREMIUM

PREMIUM

I need to form a set analysis to incorporate followings!

CLASS_CODE= MC,M4, CR_MONTH<>TR_MONTH, ME_CODE<>{DIR} & CR_PREMIUM > PREMIUM (When these conditions are met, answer to be Rs 250. I have formed a set expression & it should be ok up to cr_premium & premium combination. Please help me to add it to this & get the output.

SUM({<CLASS_CODE={'MC','M4'},CR_MONTH-=TR_MONTH,ME_CODE-={'DIR'},CR_PREMIUM>PREMIUM>}250))))

Thanks

Neville

[nevilledhamsiri]

Any body please help me on this!. Since I load two sets of data, proposed expressions are giving errors!

SUM({<CLASS_CODE={'MC','M4'},CR_MONTH-=TR_MONTH,ME_CODE-={'DIR'},CR_PREMIUM={"= CR_PREMIUM>PREMIUM"}>}250))))

[nevilledhamsiri]

If I need to charge Rs 250, when CR_Premium is less than Premium, & I arrange it such as premium={"=premium>CR_PREMIUM"}>}250 with other variables written as it is. But the expected out put wont comes. Hope some body may help me on this.

Regds

Neville

SUM({<CLASS_CODE=

{'MC','M4'},CR_MONTH-=TR_MONTH,ME_CODE-={'DIR'},CR_PREMIUM={"= CR_PREMIUM>PREMIUM"}>}250))))