Why does the Query Result display "X" as a result

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[former_member188975]

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...

[Former Member]

Ignore..

Message was edited by:

Jr Roberto