Formula help

[claudio]

Hi Alex,

Please I need your help, I have the following problem, I have a customer with field time in minutes, sample 479 minutes show in cell 7,59 in the excel the formula =INT(A1/60)+(A1-INT(A1/60)*60) /100, but I don't found function like Int or Round in pivotcube.

begin
VAR A;
VAR HORA;
VAR MINUTO;
A = "COUNT";
HORA = INT(A / 60); <- I need convert this division for integer
MINUTO = (A - HORA * 60) / 100;
Result = HORA + MINUTO;
end

thanks,
Cláudio.

[AlexZencovich]

You may use FUNC keyword to create ofw function in your delphi code via event handler OnCalcMeasureGetFunction(), you will need just add functiond eclaration in formula like

func INT;

Reslt = INT(some code here)

it will call event handler, with function name as parameter.