Expression as a number

[nick1408]

Hi again,

I'm using the following expression in a query:

Expr1: (DSum("[Total Effort]","[Scheduled NPS Tasks This Month]"))

Problem is, when I go to graph it I get told it is not seen as a number and only comes through as 1 (it is considerably larger). How do I make it so the expression is seen as a number I can graph?

 

[sneuberg]

I believe DSum returns either a number or null. Is it possible that it is returning nulls. If you just run this query outside the chart what values is this expression returning?

 

[nick1408]

I believe DSum returns either a number or null. Is it possible that it is returning nulls. If you just run this query outside the chart what values is this expression returning?

88 and something in the hundreds