Set variable using calculations

FinalBuilder Discussion
1

I'm sure it can be done but...

I want to set a variable based on a calculation involving another variable.  I've tried using the 'set variable' action but can't get it to work. 

Example using Excel functions...

Var1 = Ceiling(Var2 / 4, 1)

How can I do calculations like this in FinalBuilder and what would be the equivalent of the 'Ceiling' function?

 

Regards,

Clive

2

It’s ok. I found a way to do it using VBScript. In the BeforeAction…

Var1= int(Var2 / 4 + 1)

Clive