Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Like this???
=num(sum([PCard.Purchases]) -
Sum({<Description={'TD'},[Card Bank]={'US Bank'}>}[Amount USD])
,
'$#,##0')
Regards,
AS
Hi,
Like this???
=num(sum([PCard.Purchases]) -
Sum({<Description={'TD'},[Card Bank]={'US Bank'}>}[Amount USD])
,
'$#,##0')
Regards,
AS
Your Welcome!
Regards,
AS