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.
Solved! Go to Solution.