Visual LANSA Forum

We are developing a Visual Lansa Sales Forecasting system.

One potential method we may forecast is through the use of a "trend" in sales history using multiple years of sales data.

If we are asked to calculate this trend through the use of Linear Regression calculations (e.g. X and Y values, slope, etc), I'm curious if there are
any built-in functions and/or Operators that would help in these calculations or would we have to write custom code to do the calculations "long-hand"?

My initial search of the available Mathematical Built-In Functions only finds: Exponential, Random_Num_Generator, Round, and Square_Root.

While built-ins still supported and in use for several things, we now have intrinsic functions, which depends on the type of field and are much faster and easier to use. You just need to add a dot after the field and after a brief second Visual LANSA will display in a drop down all the different intrinsic functions available for you.

For example in this code I am defining a couple of fields as FLOAT and with that, I can use intrinsics like exponential, power, arccosine, arcsine, logarithm, power, sqrt, etc. etc :
and you can combine multiple intrinsic functions, for example:
allow autocomplete in the LANSA editor to assist you when creating the lines of codes. just press the . and wait for the dropdown to see all the options.

you can find more about intrinsic here: https://docs.lansa.com/15/en/lansa015/i ... 6_0015.htm

I doubted that there was quick "Linear Regression" built-in function, but at least knowing these intrinsic functions exist will help in us developing our own logic. Thanks