Why does the Query Result display "X" as a result
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.
Gillian Leo replied
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.