Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
gauravgg
Partner - Creator
Partner - Creator

Error while executing the following expression ?

hi

sum({$<verification_status = {"VC"}>} (sum(so_net_amount)/sum(total so_net_amount)))

4 Replies
Chanty4u
MVP
MVP

try

sum({$<verification_status = {"VC"}>}

sum(so_net_amount)  /

sum(total so_net_amount)))

gauravgg
Partner - Creator
Partner - Creator
Author

sunny_talwar

May be this:

Sum({$<verification_status = {"VC"}>} so_net_amount)/Sum({$<verification_status = {"VC"}>} TOTAL so_net_amount)

or this:

Sum({$<verification_status = {"VC"}>} so_net_amount)/Sum(so_net_amount)

gauravgg
Partner - Creator
Partner - Creator
Author

thanks sunny

this worked

Sum({$<verification_status = {"VC"}>} so_net_amount)/Sum({$<verification_status = {"VC"}>} TOTALso_net_amount)