Condition

[master_student]

hello

I need to implement this condition  :=if (sum(ARPU)=0, count(DN_NUM))

but the result is nothing :

Thanks

[rahulpawarb]

Hello Wiem,

I hope that you are doing good!

As per my understanding, the expression you have used has Sum(ARPU) value greater than 0. Due to this it is showing no value (else part of if statement). You can validate it by revamping your expression as below:

=if (Sum(ARPU)=0, Count(DN_NUM), 'Sum(ARPU) is non zero')

Hope this will be helpful.

Regards!

Rahul

[jonathandienst]

Er, with that information, you want us to help exactly how? I have misplaced my magic wand.

[master_student]

The expression is ok but i didn't get nothing as a result, i just need to know the reason :

i need to know the number of dn_num that have a null arpu

[tresesco]

May be like:

Count(Distinct {<DN_NUM={"=len(trim(APRU))=0"}>}DN_NUM)

[rahulpawarb]

Hello Wiem,

You can also refer below given expression:

Sum(If(Len(APRU) = 0, 1))

Regards!

Rahul

[Anonymous]

You are looking for a 'WHERE CLAUSE' and not an IF Statement.

Its should look like this: COUNT( {<SUM(ARPU) = {'0'}>} DN_NUM)