Skip to Content
0
Jul 01, 2022 at 03:11 PM

How to count distinct records based on some condition

830 Views

Hi HANA Experts,

I want to count the distinct records based on some conditions. I tried with Counter, but it is not working as expected.

Please find the sample data.

image.png

I want to count the distinct records based on the below condition.

For counting Distinct Sales Order Number.

IF("RECORD_TYPE" ='SO' AND ("SO_NUMBER" != '') AND "FLAG" = ' ')

For counting Distinct Service Order Number

IF("RECORD_TYPE" ='SO' AND ("SR_NUMBER" != ' ') AND SO_STATUS = 'CLOSED')

Pls guide, how to achieve.

Thanks.

Attachments

image.png (22.8 kB)