If you hide #Error or 0 whole row will be excluded will that be ok
or you want to make them blank?
Kindly let us know will help you with the solution
i just want to make them blank and keep the other values.
Where did the error values come from? I can't say I recall seeing this in Tableau...
Most Likely it is Divison by 0
It is a calculated member created with MDX since I'm connected to a cube. So this is exactly the structure/figures I want to have. But the 0 and #error should be hidden.
What is the data type of the field in Tableau?
the result type is "Float". It is a calculated measure.
Can you do a calculated field, something like this?
IF STR([Field])="#Error" or STR([Field])="0" THEN
Hi, just following up to see if we have adequately addressed your question. If so, could you please mark one of the responses as the correct answer? If not, please let us know how else we can help. Thanks!