Function IF or IF in expression

[#1]

Hello i have a problem with my expression "if or if" maybe you can help me :

i try to calculate an expression with this :

if([Site Facture]= 'PX', (CMSPSX*Qte), [Site Facture]) or if([Site Facture]= 'FV', (CMSFV*Qte), [Site Facture])

but my results is "-1" and i don't know why.

Maybe you can help me ?

I have join an exemple of my problem

Best regards

[sunny_talwar]

May be this?

if(Match([Site Facture], 'PX', 'FV'), (CMSPSX*Qte), [Site Facture])

[sfatoux72]

Use :

Rangesum(if([Site Facture]= 'PX', (CMSPSX*Qte), [Site Facture]), if([Site Facture]= 'FV', (CMSFV*Qte), [Site Facture]))

[#4 · Accepted solution]

i have solve my problem with this expression :

If( Site_Facture = 'PX',

sum(CMS*(Qté_Facturé*Coef_UV_US)),

  if( Site_Facture = 'FV',

   sum(CMSFV*(Qté_Facturé*Coef_UV_US))

     ))

The problem was the labels, don't working on my function. I have use the full operation.

[sfatoux72]

or simply :

Rangesum((CMSPSX*Qte), (CMSFV*Qte))

Rangesum manage null value

[sfatoux72]

Or better:

Rangesum(CMSPSX, CMSFV) * Qte