VarName = FORMULA(<(expressions)><(expressions)>...) 	
	(optional : variables) ,ivalue, Lvalue, fvalue, dvalue,     )   ;

	  
  -The variables are defined using the following convention:  %i integer, %l long ,%f float ,%d double  
   

	
	
 	
	

   
float : fvalue dec(2) ;
Double : dvalue dec(2);
long   :   lvalue;
integer:   ivalue;
Display "--------------------------------------------------------- " ;
Display "                     Example complex/scientific FORMULA  " ;
 BEGIN 
  
	Dvalue := Formula(  "(  (((2*30)+50 )^2)- ( (20-6 ) *2 ) ) *1000000 /( (1000/2) *4 )"   ) ;

Dvalue :=  Formula(" Sin(0.25 * PI)^2");
 
Dvalue :=  Formula(" exp(20)");
Dvalue :=  Formula(" ABS(234)");
Dvalue :=  Formula(" Sin(1200*5)");
Dvalue :=  Formula(" 2.5 * ( 3 + 1.1 * Sqrt(25))");

dvalue := Formula(" 3.5^2"); 
 ** VARIABLES !!!!
 ivalue:= 2; Lvalue := 30;fvalue :=1000;
 
 clear dvalue;
  dvalue := 1000000;
		Dvalue := Formula(  "( (((%i*%l)+50 )^2)- ( (20-6 ) *%i ) ) "+
	                    " *%d /( (%f/2) *4)",ivalue,Lvalue,ivalue,dvalue,fvalue    ) ;

         Display "Formula   VARIABLE :  Double value = ", Dvalue;
	

   
float : fvalue dec(2) ;
Double : dvalue dec(2);
long   :   lvalue;
integer:   ivalue;
Display "--------------------------------------------------------- " ;
Display "                     Example complex/scientific FORMULA  " ;
 BEGIN 
 
 ** VARIABLES !!!!
 ivalue:= 2; Lvalue := 30;fvalue :=1000;
 
 clear dvalue;
  dvalue := 1000000;
		Dvalue :=  Formula(  "( (((%i*%l)+50 )^2)- ( (20-6 ) * %i ) ) "+ 
	                    " *%d /( (%f /2) *4)",ivalue,Lvalue,ivalue,dvalue,fvalue    ) ; 

         Display "Formula   VARIABLE :  Double value = ", Dvalue;
	

Pre-requisites

Mathematical function with constants that can be arithmetic ABS , EXP ,SIGN,SQRT,LOG,LOG10 trigonometric SIN,COS,TAN,ASIN,ACOS,ATAN probability FACTORIAL
othes E 2.7182818284590452353602874713527
PI 3.1415926535897932384626433832795

Remarks

The variables are defined using the following convention: %i integer, %l long ,%f float ,%d double

---

Interested in joining us? contact@mgplanete.com
The Mg Planete team

---

Copyright 2022 by Mandragore Planete

the official sites :
mgplanete.com
getms4bi.com
demos.ms4bi.com
help.ms4bi.com
ms4script.com

---

Download

official site :
getms4bi.com

---

Our purpose : Keep it simple !

written with ms4script

• help 01.010.2022.8

MS4BI in 5 minutes