expression in the set analysis

[tommasogaiaspa]

Hi, I would like to know what I have unblocked in this expression since it does not propose me any result:

sum({$<Priorità={R02}>}($(=vNIpri)))

this is the NIpri variable:

sum(TOTAL <Priorità>{<Obiettivo>}(Effettivo-[Range Min])*100*[Peso Indicatore]/([Range Max]-[Range Min])*[Peso Priorità])

Thank you

[PrashantSangle]

Check below
1: what is output of variable NIpri in text box.
2: sum({$<Priorità={R02}>}($(=vNIpri))) use " single quote around R02. like
sum({$<Priorità={"R02"}>}($(=vNIpri)))

Regards,

[tommasogaiaspa]

I tried your solution, but I don't get any results.
I am attaching the qvw test file where you can find the tables with the expressions and the graph with the error.
Thank you.

[sunny_talwar · Accepted solution]

May be try this

Sum({$<Priorità={"R02"}>}Aggr(($(=vNIpri)), Priorità))

 

[tommasogaiaspa]

Thanks for the solution