To calculate Quantity based on Units

[#1]

Hello Guys,

Looks very easy but I dont get it. Seems to be not my day. I just wanted to get the values of Quantity_in_kWh in the following example.

Hope someone can help.  See the attachment.

Thanks in Advance

Sravan

[jonathandienst]

Hi

Your environment setting is for , (comma) as the decimal separator, but your data uses a . (period); so QV does not recognise your values as numbers,

Change

SET DecimalSep=',';

to

SET DecimalSep='.';

HTH

Jonathan

PS: you could use the number interpretation function rather than changing the environment, for example:

     LOAD ...., Num#(Quantity, '#.#####', '.', ' ') As Quantity, ...

[#3]

hi jonathan,

that does not solve the problem. I think I am making some silly mistake or overlooking something. why cant I multiply the Quantity and unit to get the Quantity_in_kWh?

[maxgro]

Hi

also replace this in your script

text(Quantity) as Quantity,

with

Quantity,

Regards

[Anonymous]

you'll have to use Jonathan's snippet for Quantity and Factor.

See attached