Variable to update

[patrou38]

hello,

I'm wondering If it's possible to set a variable with the expression result.

I tried directly with the set function without success 😞

thank you in advance

patrick

[patrou38]

hello,

my Text is not in the text chart but in the 'title in the chart, in general menu'.

=choice2 &' % lot in hold <= 3 days'

and before the sympbol '%' I would like to put the result of my expression which is equal to 39% in this case.

my expression is :

=round(count({<Availability={'WIP'},[Product Type Code]={'DI'}, [Hold Status]={'HOLD'}, Division={$(choice2)}>} [Lot number]))/
round(count({<Availability={'WIP'},[Product Type Code]={'DI'}, Division={$(choice2)}>} [Lot number]))

and my dimension :

=if(Ceil(CutOffDate-[Last Op Move In])<=3,1).

if I put my expression as it is, it's working but the number is wrong because it doesn't take my dimension into account.

hopping that you understand my problem.

Regards,

Patrick

[vishsaggi]

It is now time to share your sample app, it is tough to give you assuming answers coz i am not sure until i have something to work on? Can you scramble your data and send me your sample app?

[vishsaggi]

Can you use

= '$(choice2)' &' % lot in hold <= 3 days'

[patrou38]

hello,

the variable "choice2" works properly. what I would like to stock on another variable is the result of my expression taking into account my dimension.

do you have any idea of how I can do that ?