topic Re: Count the distinct bond which have payment status is 1 for all repeating bond in App Development

Count the distinct bond which have payment status is 1 for all repeating bond

narender123 — Wed, 23 Jun 2021 11:13:53 GMT

Hello Team,

I have 2 column in my table. Bond and paymentstatus.

I want to count distinct bond for those whose paymentstatus is 1 against all same bond type.

Example:

Load * inline

[

bond,paymentstatus

a,1

a,0

a,1

b,1

c,1

c,0

d,1

];

The result should be 2 as bond b and d has payment status 1 for the same bond type.

Thanks,

Narender

sunny_talwar — Wed, 23 Jun 2021 11:38:46 GMT

Try this

=Count(DISTINCT {<bond = e({<paymentstatus -= {'1'}>})>} bond)

narender123 — Wed, 23 Jun 2021 12:04:56 GMT

Hello Sunny,

Thank you, It is working fine.

Can we use possible records p() rather than exclude e().

like:

=Count(DISTINCT {<bond = p({<paymentstatus = {'1'}>})>} bond)

This is showing wrong data. Can you tell me?

Narender

sunny_talwar — Wed, 23 Jun 2021 12:17:26 GMT

This won't work because it will include bond where paymentstatus = 1 even once

narender123 — Wed, 23 Jun 2021 12:27:55 GMT

ok, Thanks.

I used 1 more expression that is also giving the right result.

=count({<productstatus={1},bond={"=count(distinct productstatus)=1"}>}distinct bond)

Thank you.

Narender