topic Re: transform formula to script in App Development

transform formula to script

olguita2014 — Sat, 16 Feb 2019 18:08:03 GMT

Hi,

Help me please!!!!..... I want to put this expression Sum({<KARFECHA={"<=$('$(=MAX(KARFECHA))')"}>} Cantidad_Saldo) into the script.

Re: transform formula to script

uacg0009 — Mon, 18 Feb 2019 08:16:40 GMT

Hi,
some questions:
1.what's the data type of "KARFECHA"? a date?
2.do you want to put it in a table? if yes, what's the dimensions/columns of this expression?
3.how about putting it into a variable in script?
Aiolos Zhao

Re: transform formula to script

olguita2014 — Sun, 24 Feb 2019 22:18:02 GMT

Hi,

Please help me!!!!!!.... I want to get the last record of city by date range. Example:

I have this information:

vehicle model	city	DATE
AAA	A1	1/2/2017
AAA	A2	28/2/2017
AAA	A3	23/2/2019
BBB	B1	18/2/2017
BBB	B2	23/3/2018
BBB	B3	17/2/2019

and when I choose one date, for example 23/3/2018 (rate of dates less or equal to the current selection)the result should be:

DATE 23/3/2018

vehicle model	city
AAA	A2
BBB	B2

if i select this DATE 23/2/2019

vehicle model	city
AAA	A3
BBB	B3

Re: transform formula to script

uacg0009 — Mon, 25 Feb 2019 05:57:32 GMT

Hi Olguita,

I think below is what you want, please see the attachment:

Aiolos Zhao