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

Anonymous — Tue, 30 Jan 2018 14:01:01 GMT

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

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

lojdr — Tue, 30 Jan 2018 16:35:05 GMT

Hello,

What about something like this?

Anonymous — Tue, 30 Jan 2018 17:58:51 GMT

Thank you
my problem is resolved