Hi

I have a dataset (using Excel-file as a source) from where I get values with vlookup, but I am unable to set units properly.

Values retrieved from a matrix have these square brackets around them [], and it makes working with units really difficult.

I was able to convert mm to m (my database has plain values, but they are supposed to be mm). But next step is to display final results in kN/m, but I keep getting kg/s^2.

I am able to remove units completely and display the correct result without units displayed, but this is suboptimal.

EDIT: I'm using importData plugin

Suggestive ...

You either need to alter your dataset or do corrections after import.
I am not promising anything but maybe units can be imported as they are.
But we need your dataset and smath file for to check if it can be done.

Regards

Wrote

... I was able to convert mm to m (my database has plain values, but they are supposed to be mm). But next step is to display final results in kN/m, but I keep getting kg/s^2. ...

Hi. Something like this?



Best regards.
Alvaro.

Wrote

Suggestive ...

... Think in terms of sub-utilities you may need to apply.

Wrote

Hi. Something like this?

Best regards.
Alvaro.

My guess is his data is something like this.
That's what I deduce from his description at least.
Without him posting datasheet we can't help any further.

File not found.File not found.

Thanks for your replies, here are the files.

I would like to display variable z as kN/m instead of that kg/s^2

You have to customize the result units in the rightmost placeholder.

Wrote

You have to customize the result units in the rightmost placeholder.

Thank you! I don't know how I didn't get that working couple days ago, I tried to write units outside of brackets but didn't succeed. But now it works no problem

You're welcome