If function and hopefully explantaion

[#1]

Hello I have a problem where I have a list of ID's and I only want the numerator for one so i have tried this expression

=if(match([Indicator ID]=220,sum(TOTAL(Numerator)))

but there is something wrong with the IF function, could anyone give me a solution and possibly an explantion of how IF functions work so that I could understand as I am being confused by it?

Thanks in advance for any answers

[sunny_talwar · Accepted solution]

Try this:

=Sum({<Indicator = {220}>} Numerator)

or

=Sum(TOTAL {<Indicator = {220}>} Numerator)