Expression error

Fri, 10 Oct 2014 06:55:37 GMT

Dear Al,

Part of my table was posted above. and two simple expressions i wrote for BRO_ORC and AGE_ORC are sown below.

SUM({<Cat={BR},POSI={ME}>}COM_PRE*BR_COM_ORC)/100

sum({<Cat={'AG'},POSI={ME}>}COM_PRE*AG_COM_ORC+SR*AG_RS_ORC+TC*AG_TC_ORC)/100

But you can see the ME commission was calculated in both BRO_ORC and AGE_ORC columns. Instead it should be calculated only on AGE_ORC

can you find whats wrong with my two expressions.

Early reply will be highly appreciated.

Regards,

Priyantha.

Re: Expression error

phaneendra_kunc — Fri, 10 Oct 2014 07:12:39 GMT

do you have POSI = ME for CAT = ME?

Also you are referring Cat with just first letter capital. Qkikview field names are case sensitive

Fri, 10 Oct 2014 07:28:10 GMT

Dear Kunche,

Thanks for early reply.

just i change the CAT=ME as CAT=INT

but still the results are same

if i change the Cat as CAT in my expression, it make bad expression.

Please help me in this regard.

Priyantha.