**Fields**

Asked_Amount

Partial_Amount

State

So, I would like to retrieve:

- (one column) sum all the rowsvalues of Asked_Amount IF State='1' AND Partial_Amount IS Null**

Tested to create a column with this statement and returned error. But If I remove the second condition it works.

CASE WHEN State = '1' AND [Partial_Amount] = 'IS NULL' THEN [Asked_Amount] ELSE 0 END

- (one column) sum all Partial_Amount

Tested and works:

SUM([Partial_Amount]) AS Total_Partial_Amount

- (one column) the sum of these two columns

Haven't tested anything yet since I couldn't even solve the 1st one.

What am I doing wrong? Thanks in advance.