Creating a "Total" box based on amount fields

[#1]

I am new to Qlik so this may be simple...

I am looking to create a statistics box at the top that will show the total sum of a certain field given a condition. For example, I want to create a box that just has "Total Assets: $650.00", and another one that would say "Total Liabilities: $50.00". Hopefully this is a simple solution!

Account Type	Account Number	Amount
Asset	1100	$100.00
Asset	1200	$350.00
Liability	2200	$50.00
Equity	3410	$105.00
Asset	1300	$200.00

[el_aprendiz111]

Hi,

texbox1

=sum({<[Account Tpe={'Assent'}>}Ammount)

textbox2

=sum({<[Account Tpe={'Liability'}>}Ammount)

[el_aprendiz111]

Hi,

texbox1

=sum({<[Account Tpe]={'Assent'}>}Ammount)

textbox2

=sum({<[Account Tpe]={'Liability'}>}Ammount)

[devarasu07]

Hi,

Try like below,

Text Box object: 1

='Total Liabilities: '& num(sum({<[Account Type]={'Liability'}>}Amount),'$#,##0.00')

Text Box object: 2

='Total Assets: '& num(sum({<[Account Type]={'Asset'}>}Amount),'$#,##0.00')

Thanks,

Deva