Error in set modifier expression

[MattReinders]

Hello All, 

Look for some help here as I am running into a Error in Set Modifier Expression.  Here is the expression: 

=num(sum({<[PCard.Purchases] - Sum({<Description={'TD'},[Card Bank]={'US Bank'}>}[Amount USD])),'$#,##0')

The goal is to subtract ({<Description={'TD'},[Card Bank]={'US Bank'}>}[Amount USD]) from [Pcard.Purchases] 

Really appreciate the help. 

Matt

[sunny_talwar]

What is PCard.Purchases? Is it a field?

[amit_saini · Accepted solution]

Hi,

Like this???

=num(sum([PCard.Purchases]) -

Sum({<Description={'TD'},[Card Bank]={'US Bank'}>}[Amount USD])
,

'$#,##0')

Regards,

AS

[MattReinders]

Yes PCard.Purchases is a field

[MattReinders]

Amit, thank you!

[amit_saini]

Your Welcome!

Regards,

AS