Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Could use some help here. I am not sure why how to get this statement to work. Right now it has errors and I'm not sure how to make it correct.
= num(sum([Fiscal Year] = {$(=vCurrentYear)}, [Line Item Amt USD]), '$#,##0')
Perhaps this?
= num(sum({<[Fiscal Year] = {$(=vCurrentYear)}>} [Line Item Amt USD]), '$#,##0')
Or
= num(sum({<[Fiscal Year] = {"$(=vCurrentYear)"}>} [Line Item Amt USD]), '$#,##0')
Or
= num(sum({<[Fiscal Year] = {"$(vCurrentYear)"}>} [Line Item Amt USD]), '$#,##0')