Pick match valuelist

Ronald — Sat, 16 Nov 2024 04:52:22 GMT

Tengo el siguiente código en una tabla con valuelist():

num(sum( {<Stream={'IMS DATA'},Corporation={'Sanofi Corp','Sanofi INN'},Periodo={'MTH10'}>} aggr( Tot, Country,[Country Core],Stream,DB,Corporation,[Owner BU],Duplicado,Cluster,Family, Tot))/sum( {<Stream={'IMS DATA'},Periodo={'MTH10'}>} aggr( Tot, Country,[Country Core],Stream,DB,Corporation,[Owner BU],Duplicado,Cluster,Family, Tot)) ,'#.0%')

Pero no muestra el resultado en mi tabla.

PICK(MATCH(VALUELIST($(vLista)),$(vLista)),
$(vF1C11),
$(vF2C11),
$(vF3C11),
$(vF4C11),
'',
$(vF6C11),
$(vF7C11),
$(vF8C11),
$(vF9C11),
$(vF9.1C11),

'',
num(sum( {<Stream={'IMS DATA'},Corporation={'Sanofi Corp','Sanofi INN'},Periodo={'MTH10'}>} aggr( Tot, Country,[Country Core],Stream,DB,Corporation,[Owner BU],Duplicado,Cluster,Family, Tot))/sum( {<Stream={'IMS DATA'},Periodo={'MTH10'}>} aggr( Tot, Country,[Country Core],Stream,DB,Corporation,[Owner BU],Duplicado,Cluster,Family, Tot)) ,'#.0%'),
$(vF12C11),
$(vF13C11),
$(vF14C11),
'',
$(vF16C11),
'')

Re: Pick match valuelist

Yoshidaqlik — Mon, 26 Aug 2019 16:27:16 GMT

Hola

Creo que solo faltaba alguna función de medición para AGGR

num( sum({<Stream={'IMS DATA'},Corporation={'Sanofi Corp','Sanofi INN'},Periodo={'MTH10'}>} aggr( sum(Tot), Country,[Country Core],Stream,DB,Corporation,[Owner BU],Duplicado,Cluster,Family ) ) / sum({<Stream={'IMS DATA'},Periodo={'MTH10'}>} aggr( sum(Tot), Country,[Country Core],Stream,DB,Corporation,[Owner BU],Duplicado,Cluster,Family ) ) ,'#.0%')

saludos

topic Pick match valuelist in App Development

Pick match valuelist

Re: Pick match valuelist