How to compare two values to hold back one and insert it

[Anonymous]

Hi all, 

I have some problem, i want find your support please.

I have a source table "Medicament " and a target table "dim_medicament".

in Medicament i have two variables "PrixUnitaire" and "EtatMed" 

PrixUnitaire is an float

and EtatMed is an integer (who take the 1 if medicament it's available and 0 if isn't)

In the target table , i want add a "Prix" variable who receive the "PrixUnitaire" if the medicament is available and 0 if isn't.

for dim_medicament.Prix i wrote this expression , and i found a some mistakes:

 (Medicament.EtatMed = 1) ? (Prix = Medicament.PrixUnitaire) : (Prix = 0) 

I ask your help above.

Thank you

[lojdr · Accepted solution]

Hello,

What about something like this?

[Anonymous]

Thank you
my problem is resolved