Need front end logic help to write expression.

[lalitkgehlot89]

Hi,

With attached data I want to calculate incentive on the basis of sales achievement.

Please help me out to wright the expression on front end.

Incentive calculation :-

if Sales Achievement <90 then 0

if Sales Achievement >=90 and <95 then (0.90% of Sale)

if Sales Achievement >=95 and <100 then (1.00 % of Sale)

if Sales Achievement  >100 and <110 then (1.25 % of Sale)

if Sales Achievement >110 then (1.35% of Sale)

[awhitfield]

Hi See attached rough and ready example

Should get you started

HTH

Andy

[Anil_Babu_Samineni]

May be this?

if([Sales Achievement] <90, 0,

if([Sales Achievement] >=90 and [Sales Achievement]<95, Sum(Sale)*0.9,

if([Sales Achievement] >=95 and [Sales Achievement]<100, Sum(Sale)*1,

if([Sales Achievement] >100 and [Sales Achievement]<110, Sum(Sale)*1.25,

if([Sales Achievement] >110, Sum(Sale)*1.35)))))

[lalitkgehlot89]

thanks a lot Andrew.

[lalitkgehlot89]

thanks a lot anil.