(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?

[dpudukota]

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:

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

[VolkerEckardt]

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