How to I sum one column ONLY when another column is NOT NULL

KellyMc — Sat, 16 Nov 2024 18:11:52 GMT

I have a table with month, category, ACTUAL Revenue, and PROJECTED Revenue as variables. The Actual revenues are populated only for year-to-date (by month) so when I sum them, I get the Actual YTD revenue.

I want to calculate the YTD Projected Revenue by counting ONLY the monthly projected revenue values where the matching Actual Revenue value is NOT NULL.

I tried doing this multiple times and thought the following expression would work, but it's returning zero.

=sum({<Actual={'>0'}>} Projection)

Re: How to I sum one column ONLY when another column is NOT NULL

tresB — Mon, 24 Aug 2020 05:14:22 GMT

Try like:

=sum({<Actual={">0"}>} Projection) // double quotes for greater than zero

Or,

=sum({<Actual={"*"}>} Projection) // for not null

topic Re: How to I sum one column ONLY when another column is NOT NULL in QlikView

How to I sum one column ONLY when another column is NOT NULL

Re: How to I sum one column ONLY when another column is NOT NULL