pick

[fmazzarelli]

Hi Community,

I'm using this function

Pick(Match($(vColli),1,2),sum([SteColli]),sum([colliAP]))

but I receive the error message 'Dimension is not valid'

Could you help me?

[sunny_talwar]

You are using this as a dimension or expression?

[fmazzarelli]

dimension

[sunny_talwar]

You would need a Aggr function in that case since you are using Sum() function.

[jagan]

Hi,

I think this should be a expression instead of Dimension.

Regards,

jagan.

[fmazzarelli]

that means

Pick(Match($(vColli),1,2),Aggr(sum([SteColli])),Aggr(sum([colliAP])))