Issue with passing variable in a pick expression

[#1]

My expression works fine.

=$(vTriangle(

$(=

sum({<$(vCalendarIgnoreSA), Link_Date={'$(=vToDate)'}>} NewEsignApprovals)

-sum({<$(vCalendarIgnoreSA), Link_Date={'$(=vToDatePrior)'}>} NewEsignApprovals)

)))

But when I try to put a pick, it throws an error, any idea why?

=pick(vTimeDim,$(vTriangle(

$(=

sum({<$(vCalendarIgnoreSA), Link_Date={'$(=vToDate)'}>} NewEsignApprovals)

-sum({<$(vCalendarIgnoreSA), Link_Date={'$(=vToDatePrior)'}>} NewEsignApprovals)

))),' ')

All suggestions and help greatly appreciated.

-Roy

[Digvijay_Singh]

Not sure but the only difference I could see is '=' sign before the expression when using pick.

[Clever_Anjos]

does vTimeDim returns which type of numbers?

[susovan]

Hi Aditya,

You can also try this,

=pick(Match(vTimeDim,$(vTriangle($(=sum({<$(vCalendarIgnoreSA), Link_Date={'$(=vToDate)'}>} NewEsignApprovals)

-sum({<$(vCalendarIgnoreSA), Link_Date={'$(=vToDatePrior)'}>} NewEsignApprovals)

)))),' ')