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.