topic Re: multyply variable with field value in QlikView

multyply variable with field value

PeterHenskens — Mon, 26 Nov 2018 06:32:00 GMT

hi,

feel kinda stupid posting this one, its prety much a basic calculation but keeps on failing, cannot find the reason.

I have created a variable that indicate the course USD - EUR looks like this:

SET Dollar_EURO=0,8819;

then the calucation is a field with USD values, I want to return the EUR values so made this one:

Total_Charge * $(Dollar_Euro) as Total_Charge

very simpel, --> value of the field * 0,8819

any idea's of where i made a mistake/ need to add?

thanks.

tresB — Mon, 26 Nov 2018 06:41:02 GMT

May be a typo :

Total_Charge * $(Dollar_EURO) as Total_Charge // 'Euro' in capitals

PeterHenskens — Mon, 26 Nov 2018 06:51:52 GMT

hey,

indeed a typo, thanks 🙂