Formatting problem - numeric or not?

datanibbler — Wed, 01 Apr 2015 14:26:15 GMT

Hi,

I have the following problem:

- From one file, I get a ready-made figure (which is cost_per_minute), that is numeric and has 4 decimals.

- From another file, I have - actually the same figure, cost_per_minute.

<=> My problem is, that second figure has 8 decimals and I want only 4 - I need to re-do a calculation like our customer

has done it with 4 decimals, so I need to avoid rounding errors.

<=> For some reason, I can't seem to be able to format that with just 4 decimals.

I can attach the Excel_file that I use to get the second figure (it's the last line; It has 8 decimals like I said, though it's now formatted with 4; I need just 4); The first one, which has just 4 decimals, is below in the same file.

=> I want to concatenate both those figures in one table.

Can anyone help me do that?

Thanks a lot!

Best regards,

DataNibbler

Re: Formatting problem - numeric or not?

datanibbler — Wed, 01 Apr 2015 14:33:31 GMT

Okay,

I have made it now. Excel has strange ways ...

I used round() with the required starting_value in the end. I've no idea, though, why that worked now and num() didn't work.

topic Formatting problem - numeric or not? in QlikView

Formatting problem - numeric or not?

Re: Formatting problem - numeric or not?