trying to do sums with count I need some help please?

[#1]

count({sum((BILL_DOLLARS)/sum(AVAIL_DOLLARS))<=$(vBillSlider)}EmployeeID)  any help would be appreciated please

[sujeetsingh]

Why using count when already using SUM()

[#3]

try this

Count(if((BILL_DOLLARS / AVAIL_DOLLARS)<=$(vBillSlider),EmployeeID))

[kumarnatarajan]

Hi,

Try this one.

Ex:

=Count(DISTINCT if((sum(BILL_DOLLARS)/sum(AVAIL_DOLLARS))<=$(vBillSlider),EmployeeID))

Else

try this in set analysis.

=count(DISTINCT {$<EmployeeID={"=$(=(sum(BILL_DOLLARS)/sum(AVAIL_DOLLARS)) <= $(vBillSlider))"}>}EmployeeID)