Formula setting variable

[clovati]

Dear all....

I have a variable:

eGMS = Pick(Match(GetCurrentField([MM-WK-GG]), 'DataVend', 'MMM', 'WK'), 'G', 'M', 'S')

In some cases, there is a button that put eGMS = 'G'.

With a trigger when I leave the sheet (where there is the button) I am trying to give the variable the formula variable but I'm not able :-(.

I tried also with a 2nd variable i.e.:

* eGMS_Formula = Pick(Match(GetCurrentField([MM-WK-GG]), 'DataVend', 'MMM', 'WK'), 'G', 'M', 'S')

* trigger : eGMS = $(eGMS_Formula)

* trigger : eGMS = '$(eGMS_Formula)'

but I've not the possoibility to make variable as expression/ formula.

THANKS a lot!

CriL

[clovati]

Da: Onno van Knotsenburg

Inviato: mercoledì 18 novembre 2015 16:26

A: Lovati Cristina

Oggetto: Re: - Formula setting variable

[oknotsen]

Hmmm... Apparently your interface looks different then mine.

Anyway,

I marked it for you.

[Peter_Cammaert]

Rob,

I was assuming that she wanted to assign the formula string to the variable, instead of the formula result. Wrong assumption apparently.

BTW your post below does the same but in a much more efficient way.I learned a thing, again. Thanks.

[Edit] On rereading your post, I finally saw that you omitted the equal sign. Pfffft, it's getting worse... I should become a member of your "we test before we post"-association