on 09-11-2008 3:07 PM
hi, I have to move bex query result into access. I am trying to import it but it give me error because some cells in excel file contain asterik sign * and values are hidden underneath. I can see the values in formula field when i click on asterick in cell. Any Idea how to change these * to original value.
regards,
w
This is due to mixing key figures with different units of measure.
Use a nodim function to remove UOM, or, better, put the UOM in the rows, this will split the results according to the UOM.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.