Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
MattReinders
Contributor II
Contributor II

Error in num(sum( statement

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')

1 Reply
Anil_Babu_Samineni

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')

 
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful