Error in Expression

[#1]

Dear Experts,

Just i wanted to calculate the 'BRO_COMM','AGE_COMM' and 'GRO_COM ' in my pivot table. Just help me to do one of this as i'm learner in Qv.

I have used following expression to calculate the 'AGE_COMM'.

IF(CAT='AG' AND CLA_CODE='PP' AND RANGE1<PREMIUM>RANGE2),SUM(AGE_COM)

Can you any one show me the mistake i have done in my expression.

Sample file is attached herewith.

Rgds,

Priyantha.

[#2 · Accepted solution]

Dear All,

In my data base there are many products under 'CLA_CODE',  within this cla_codes there a many sub products and Those are named as 'PRD_CODE'

Ex:-  CLA_CODE          PRD_CODE

          PP                    SE

          PP                    SA

          PP                    DD

          PP                    LI

          MC                    1A

          MC                    1B

          MC                    1C Like that,

in 'DD','SE','SA' and 'LI' Prd_code there are different premiums(prices) which are entitled different Commission amounts to the respective marketing force.

Then i have build three arguments in my basic formula,

1st and 2nd arguments are in order(expected output coming)

3rd one is 'RANGE1<PREMIUM<RANGE2'. Even though expression got 'OK',

This is not working as per my testing. Dear friends, please help me to find the mistake i have done or propose an alternative way to do this.

Rgds,

Priyantha.