on 10-17-2007 7:18 PM
Hello All,
I have a query in which there are 6 Characteristics and 1 calculated key figure. But when the query is executed the query result displays as "X" in the column against all the 6 characteristics.
Can anybody provide solution as to why the result displays "X" as a result.
Regards,
Vikram
Vikram,
If your calculation is dividing a key fig by 0 you will get a red X.
Mixed units of measure will return an '*' when you run the query.
Double check the values that your formula is working from and this may give you an idea of whats causing the error.
Regards
Gill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello all,
Everybody answered it correctly. But when i debugged the query, i did not get any calculation which is getting divided by 0 and there were no mixed units of measurements. Probably it was an erroneous transport earlier. I only created and request again and transported the query from dev and the query is running fine.
Thanks everybody.
Vikram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
What have you done in the calculation? Could be a problem there..check that and use NOERR() to get rid of the "X".
Hope this helps...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ignore..
Message was edited by:
Jr Roberto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.