Create variable in script vs variable settings

Hakan_Hansson — Fri, 14 Oct 2022 09:02:46 GMT

I'm fond of the new syntax for set analysis and is experimenting to put set expressions into master items. At this point I also try to read these expressions from variables. I do see problems when creating such variable in script vs in variable area.

Example:

In script I create:

LET vMaxDateMonthEnd = '=MonthEnd(Date(Max(Datum)))';
SET vSA_MaxDateMonthEnd = {<Källa={'ANST_Månad'}>}{<Datum={">=$(vMaxDateMonthEnd)"}>};

After script load I have the following variable in variable area, see picture. I have no problem, though, to CREATE such variable in variable area (even if the syntax check complains) and use it accordingly in my application.

So there is a solution but I do prefer creating variables in script for reuse and source control. Is there a script solution to make the variable to 'stay' as defined in the SET creation? I do have tried many different syntax alternatives but they all end up as:

{<Källa={'ANST_Månad'}>}{<Datum={">==MonthEnd(Date(Max(Datum)))"}>}

It is the expansion of $(vMaxDateMonthEnd) that ruins my day. 😎

Re: Create variable in script vs variable settings

RsQK — Fri, 14 Oct 2022 11:42:15 GMT

Hi, try it like this instead:

SET vMaxDateMonthEnd = '=MonthEnd(Date(Max(Datum)))'; LET vSA_MaxDateMonthEnd = REPLACE(REPLACE('{<Källa={‘ANST_Månad‘}>},{<Datum={">=#(vMaxDateMonthEnd)"}>}','‘',CHR(39)),'#','$');

topic Create variable in script vs variable settings in App Development

Create variable in script vs variable settings

Re: Create variable in script vs variable settings