Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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