Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

Formatting problem - numeric or not?


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

1 Solution

Accepted Solutions
datanibbler
Champion
Champion
Author

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.

View solution in original post

1 Reply
datanibbler
Champion
Champion
Author

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.