topic Pick(Match(ValueList in App Development

Pick(Match(ValueList

jworthulf — Wed, 07 Dec 2022 19:03:50 GMT

I'm using Pick(Match(Valuelist to populate a chart using variable. I have a variable assigned to Delivery_Miles and it's showing a null value in my chart. If I move the variable to a text object it works. Looking for a solution.

Pick(Match(Value list chart

Text Box

Variable

$(e_DeliveryMilesRate) =

sum({1<Denominator = {'miles'}, Allocated = {0}, JJ_GL_Group = {Delivery}>*
1<Include_AR_Adjustments = P(Include_AR_Adjustments),companyID = P(companyID), WeekBased454.Year = p(WeekBased454.Year), WeekBased454.Month = p(WeekBased454.Month)>}total #GL_Total_Amt)

if(Total_Delivery = 1,sum(aggr(sum({1<Include_AR_Adjustments = P(Include_AR_Adjustments),companyID = P(companyID), WeekBased454.Year = p(WeekBased454.Year),
WeekBased454.Month = p(WeekBased454.Month)>}distinct totalMiles),ship_dt)))

Re: Pick(Match(ValueList

rachel_delany — Mon, 12 Dec 2022 01:57:58 GMT

Can you wrap the whole variable expression in NUM()

Re: Pick(Match(ValueList

jworthulf — Mon, 12 Dec 2022 15:24:06 GMT

Rachel,

Thanks for the response but this is an expression in chart vs a text box and the issue is with the denominator if that helps.

Re: Pick(Match(ValueList

rachel_delany — Mon, 12 Dec 2022 22:08:41 GMT

Yeah I get that, but if you define the whole variable as num it should display properly. Or just the denominator if that's the issue. It seems like it thinks it's a text object rather than a number.

Re: Pick(Match(ValueList

jworthulf — Tue, 13 Dec 2022 14:30:51 GMT

Rachel,

Good morning, I tried wrapping the variable and the denominator as num and unfortunately it didn't fix the issue.