#1 2012-05-19 03:13:02

mahamed
New member
Registered: 1970-01-01
Posts: 5

help with expression

please i want to help me because this week my presentation and thanks so much
this is my expression :
(row3.Nature_tarification =="F"? row2.INDEX*row3.Montant_fixe
:row2.INDEX<21? row2.INDEX*row5.Montant
:row2.INDEX<41? row2.INDEX*row12.Montant
:row2.INDEX<71&&row13.Nature_tranche =="F"? row2.INDEX*row13.Montant
:row2.INDEX<71&&row13.Nature_tranche =="V"? (40*row20.Montant)+((row2.INDEX-40)*row22.Montant)
:row2.INDEX<101&&row16.Nature_tranche =="F"? row2.INDEX*row16.Montant
:row2.INDEX<101&&row16.Nature_tranche =="V"? (40*row20.Montant)+(30*row22.Montant)+((row2.INDEX-71)*row24.Montant)
:row2.INDEX<151&&row13.Nature_tranche =="F"? row2.INDEX*row17.Montant
:row2.INDEX<151&&row13.Nature_tranche =="V"? (40*row20.Montant)+(30*row22.Montant)+((row2.INDEX-71)*row24.Montant)
:row2.INDEX<501&&row13.Nature_tranche =="F"? row2.INDEX*row14.Montant
:row2.INDEX<501&&row13.Nature_tranche =="V"? (40*row20.Montant)+(30*row22.Montant)+((row2.INDEX-71)*row24.Montant))


""i want to say :
if index = F the result index *montant fixe
else
if index<21 the result  INDEX*Montant
else
if index<71  and  Nature_tranche =="F" the result   row2.INDEX*row13.Montant
else..........""

type index=float
all motant =float
the result =float
nature=string
-----------------------------------------------------------------------------------------------
thanks

Offline

#2 2012-05-19 04:05:49

phobucket
Member
Company: Knoetry
Registered: 2010-07-27
Posts: 146
Website

Re: help with expression

Hi mahamed,
Welcome to the forum!

When comparing strings use .equals instead of ==


("F".equals(row3.Nature_tarification)? row2.INDEX*row3.Montant_fixe
:row2.INDEX<21? row2.INDEX*row5.Montant
:row2.INDEX<41? row2.INDEX*row12.Montant
:row2.INDEX<71&&"F".equals(row13.Nature_tranche)? row2.INDEX*row13.Montant
:row2.INDEX<71&&r"V".equals(row13.Nature_tranche)? (40*row20.Montant)+((row2.INDEX-40)*row22.Montant)
:row2.INDEX<101&&"F".equals(row13.Nature_tranche)? row2.INDEX*row16.Montant
:row2.INDEX<101&&"V".equals(row13.Nature_tranche)? (40*row20.Montant)+(30*row22.Montant)+((row2.INDEX-71)*row24.Montant)
:row2.INDEX<151&&"F".equals(row13.Nature_tranche)? row2.INDEX*row17.Montant
:row2.INDEX<151&&"V".equals(row13.Nature_tranche)? (40*row20.Montant)+(30*row22.Montant)+((row2.INDEX-71)*row24.Montant)
:row2.INDEX<501&&"F".equals(row13.Nature_tranche)? row2.INDEX*row14.Montant
:row2.INDEX<501&&"V".equals(row13.Nature_tranche)? (40*row20.Montant)+(30*row22.Montant)+((row2.INDEX-71)*row24.Montant))

Good luck,

Ben

Offline

#3 2012-05-19 05:54:28

mahamed
New member
Registered: 1970-01-01
Posts: 5

Re: help with expression

tanks a lot but it not run i give u a pic to see the probleme and thank u for the help its my final year project

Last edited by mahamed (2012-05-19 06:04:39)

Offline

#4 2012-05-19 18:36:54

mahamed
New member
Registered: 1970-01-01
Posts: 5

Re: help with expression

heeeeeeeeeeeeeeeeeeeeeeelp

Offline

#5 2012-05-19 23:46:29

mahamed
New member
Registered: 1970-01-01
Posts: 5

Re: help with expression

please how i can write a write expression i cant find a document ??????????????

Offline

#6 2012-05-21 04:01:27

phobucket
Member
Company: Knoetry
Registered: 2010-07-27
Posts: 146
Website

Re: help with expression

Mahamed,  please send me an email with expression and the full error.

Thanks,
Ben

Offline

Board footer

Powered by FluxBB