Pick(Match(ValueList

[jworthulf]

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)))

[rachel_delany]

Can you wrap the whole variable expression in NUM()

[jworthulf]

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.

[rachel_delany]

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.

[jworthulf]

Rachel,

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