expression does work

[Anonymous]

Hi

I have an expression like below :

Sum (field1)/(field2*Count (DISTINCT field3)*7)

somehow this does not display anything in the chart if i display the expression individually like Sum (field1) and(fields2*Count (DISTINCT field3)*7) i get the graph , but not when i divide them ..what could be the reason?

Thanks

[Anonymous]

any help with this please?

[hector]

hi

maybe there are 2 or + values of field2 by row? do you have an example?

rgds

[Anonymous]

field 2 is Available hours i have a time segment say 9:am -7pm then the avaibale hours values is 10 , so when i select values 9:am - 7pm from the filter time segment then available hours value will ne 10 ...

[Anonymous · Accepted solution]

There is nothing wrong with your expression.
It could be that the second part of your expression returns zero (deviding by zero is not possible)

yes an example would be helpful...

[#6]

Hi,

Pl post an sample application by explaining your problem.

-Sridhar