I need to count how many items with out any unit price

[#1]

Hi All

I need to count how many items with out any unit price.

Below expression working fine , which can count how many items ?

count(distinct(PART_NO_))

In order to count only those items have unit price , i need add the above condiction into above expression :-

count(if([Unit Price] > 0), distinct(PART_NO_))

But it cannot work.

Can some one advise me ?

Paul

[#2]

Hi All

Enclosed is my QV doc

[jonathandienst]

Paul

This:

count(distinct if([Unit Price] > 0), PART_NO_))

should work.

HTH

Jonathan

[#4 · Accepted solution]

Please try the below expression

if(NUM( [Unit Price]) > 0 , Count(Distinct [PART_NO_]))

Thank you

AV

[MK_QSL]

Count({<[Unit Price] = {">=0"}>}Distinct Part_No)

[#6]

Hi Jona & Manish

i try both your expression , it not work , may be because my Unit Price it a Expression below , i also change to Column(1) , it also don't work :-

if(match(Currency_P,'SG'),

money(

(

Ceil(

LAND_COST_TDS_SGD/MARKUP_SUB*RATE_P

,0.5)

)

,CurrencyFormat_P),

money(

(

Ceil(

FOB_SGD_SUB*RATE_P*TRANSPORT_SUB/MARKUP_SUB*LESS

,0.5)

)

,CurrencyFormat_P)

)

Paul

[tresesco]

Please check your [Unit Price] expression per se. It shows some error.

[#8]

if there are null values in the price column, then use this if(isnull(Unit Price), Count(Distinct [PART_NO_]))

[#9]

Hi Tres

You are right , i just notice . Can you help me to count how many items with unit price ?

[#10]

Hi All

Thank you very much for the expression . So far I confirm Vardhan working fine.

Paul