Merge two working functions, fail

[#1]

Hi,

Im trying to replace "AMOUNT" in my first expression with the IF statement. But I cannot make it work.

They both work properly when trying them separately. What am I missing here? How would you merge the two?

Kind Regards,

Olle

SUM({<[FLOW TYPE]= {'XXX'}>}AMOUNT ) 

SUM(IF([FLOW EFFECTIVE DATE]<DATE and [FLOW MATURITY DATE]> DATE,AMOUNT))

[sunny_talwar]

What is the combined version that you are trying?

[Gysbert_Wassenaar · Accepted solution]

SUM({<[FLOW TYPE]= {'XXX'}>} IF([FLOW EFFECTIVE DATE]<DATE and [FLOW MATURITY DATE]> DATE,AMOUNT))