Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register 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.