4 Replies Latest reply on Feb 18, 2017 1:32 PM by Alec Guerenstein

# If amount = Empty ?

Good afternoon,

Can't figure out the formula to count empty values. My data countain IDs and amount numbers. I need to count all ID which amount is EMPTY, or equal or above 100 as per below. Result would be 3 IDs, for a total amount of 201.

Thanks a lot

KR

 id amount 1234 0 1235 0 1236 1237 1 1238 1 1239 100 1230 101 Count all ID which amounts are empty,  or equal to or above 100 ID Amount 1236 1239 100 1230 101
• ###### 1. Re: If amount = Empty ?

Hi Beatrice,

What about:   sum(iif(isnull([amount]) or [amount] >= 100 ,1,0)) ?

Cheers,

Alec

• ###### 2. Re: If amount = Empty ?

Hi,

Could you please try the below formula and check if this works.

IF ISNULL[amount] OR [amount]>=100 THEN

[amount]

END

Gourav

• ###### 3. Re: If amount = Empty ?

drag the amount measure in filter then atleast 100 and include null

then drag id and amount in rows it will give you the expected result.

1 of 1 people found this helpful
• ###### 4. Re: If amount = Empty ?

yes !!!! thank you so much Gourav !