topic Re: if col A < value, count ColB (not getting it to work) in App Development

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

ToinkToinkTigger — Mon, 17 Oct 2022 13:53:35 GMT

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.

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

martinpohl — Mon, 17 Oct 2022 13:58:12 GMT

Hi,

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

Regards

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

agigliotti — Mon, 17 Oct 2022 14:00:54 GMT

Hi @ToinkToinkTigger ,

Maybe this:

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

I hope it can help.

Best Regards

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

ToinkToinkTigger — Mon, 17 Oct 2022 14:06:57 GMT

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