cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

(1.00* count()) / (sum(query("All Untraced Requirements",Project,count()))/count()) this percentage expression is giving out put null for some cases. Could anyone help me with this issue?

Guest

(1.00* count()) / (sum(query("All Untraced Requirements",Project,count()))/count()) this percentage expression is giving out put null for some cases. Could anyone help me with this issue?

I have used this percentage expression (1.00* count()) / (sum(query("All Untraced Requirements",Project,count()))/count()) in chart, For some cases the value is null and it is as follows:

pie chart.PNG

Can someone tell what is the reason behind this strange behavior? Thanks in advance.

1 REPLY 1
Highlighted

Re: (1.00* count()) / (sum(query("All Untraced Requirements",Project,count()))/count()) this percentage expression is giving out put null for some cases. Could anyone help me with this issue?

Hello Devaki,

well, without seeing your data it is a bit difficult to help.

A value might be null if

a) you don't have any data

b) this state is not part of the type you are selecting

What always is a good idea is to use IsEmpty() function to avoid such Null values, in your case IsEmpty(...,0).

Hope this helps

Volker

Announcements