if col A < value, count ColB (not getting it to work)

[ToinkToinkTigger]

Hi all,

I have this line of code: if(([% of Completion]=100), Count([PMP Scheduled Completion Date]))

This works just fine. However, if I want to return the count for all values <100 it does not work:

if(([% of Completion]<100), Count([PMP Scheduled Completion Date]))

Difference here is the = and < sign... what am I doing wrong here using the < for ''smaller than 100'' in this case? The dataset holds values <100 for sure.

[martinpohl]

Hi,

do you want to count in script or in an expression? hwat kind of chart-type?

Regards

[agigliotti · Accepted solution]

Hi @ToinkToinkTigger ,

Maybe this:

=Count( if( [% of Completion]<100, [PMP Scheduled Completion Date] ) )

I hope it can help.

Best Regards

[ToinkToinkTigger]

Thanks that worked! Why didnt my line of code work? I used this as an expression in a bar chart.