correction of expression

[#1]

I am new to qlik,

pls. help to correct the below expression

I want to sum of column amount-Sep 2016 where main column =Account receivable

sum( {$<Main={'Account Receivable'}>}amount-Sep 2016)

[rubenmarin]

Hi Mohammed, is that the name of a filed or the caption a table column?

If it's a field, you only need to enclose the name between []:

sum( {$<Main={'Account Receivable'}>} [amount-Sep 2016])

If it's a column label I will need to know the expression that creates that column to replicate it with the condition to filter Main={'Account Receivable'}

[#3]

Hi, Ruben,

Is name of filed,

Its working after adding []

Thank You