meta data for this page
  •  

F_PROZENTE

compatibility FreeUDFLib AvERP, GrUDF

Entrypoint prozente compatible with UTF-8

Inputs/Outputs

   Input      DOUBLE     floatingpoint 1, e. g. sales price
              DOUBLE     floatingpoint 2, e. g. purchase price
   Output     DOUBLE     who many margin % between param 2 and param 1

Syntax

   Calculate the margin % between 2 values, i. e. margin between purchase price and sales price with formula: (( 100 / param 2 ) * param 1 ) - 100
   Test-SQL
   SELECT 50.000 AS ISCORRECT, F_PROZENTE(21.00, 14.0) FROM RDB$DATABASE;
   SELECT 10.000 AS ISCORRECT, F_PROZENTE(15.40, 14.0) FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_PROZENTE(NULL, NULL) FROM RDB$DATABASE;