Skip to main content
D
dpudukota1-Visitor
1-Visitor
February 13, 2017
Question

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

  • February 13, 2017
  • 1 reply
  • 1310 views
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

    V
    VolkerEckardt17-Peridot
    17-Peridot
    May 6, 2017

    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

    Terms & ConditionsCookie settingsAccessibility statement