cancel
Showing results for 
Search instead for 
Did you mean: 

Error in dataset value #div/0 encountered in chart though i m taking care of it in the variables formula.

Former Member
0 Kudos

Hi,

I am encountering #div/0 in the column chart, though I have taken care of that thing in variables formula.

And yes chart is displaying a ! warning sign.


Accepted Solutions (1)

Accepted Solutions (1)

amitrathi239
Active Contributor
0 Kudos

what is the formula where you are checking this..

or create one more variable like=if(iserror([Variable])) then 0 else [Variable]

Former Member
0 Kudos

the formula I am using is -

= If IsError([Total Number## ]/[Total Number###] Then 0  Where ([####] = "##")
ElseIf IsNull([Total Number##]) Then 0  Where ([####] = "##")
ElseIf [Total Number##] = 0  Then 0 Where ([####] = "##")
Else [Total Number##] / [Total Number##]  Where ([####] = "##")

amitrathi239
Active Contributor
0 Kudos

try this.

=if(iserror([Total Number## ]/[Total Number###])) then 0 else ([Total Number##] / [Total Number##])  Where ([####] = "##")

Former Member
0 Kudos

Nops still the same.

The chart was displaying one value  but not displaying other value.

if I am converting that chart to vertical table there also its the same #div/0.

And yes chart is displaying that one value with that warning sign.

amitrathi239
Active Contributor
0 Kudos

can you try to add iserror() with if-else function on the variable where you are getting the  error.

Let say your current variable is V Object then create one more and place this one in the column.

Final=if(iserror([V Object])) then 0 else [V Object]

Former Member
0 Kudos

Can you try below

= If ([Total Number###]=0) Then 0  Where ([####] = "##")

ElseIf IsNull([Total Number##]) Then 0  Where ([####] = "##")

ElseIf [Total Number##] = 0  Then 0 Where ([####] = "##")

Else [Total Number##] / [Total Number##]  Where ([####] = "##")

Regards

Niraj

Answers (0)