Formula (Mathematical Function) implementation in BEx 7.0

[Former Member]

Hi,

how do I implement a formula in BEx 7.0 to convert KeyFig "Z_DURATION" which is delivered in hours (eg: 1.5 h) into minutes (90 min). I tried the follwing formula, but encounter a critical error when I use this Mathematical Function logic.

FLOOR(Z_DURATION)60 + FRAC(Z_DURATION)/1060

Is this right? Pls advise. POINTS will naturally be awarded.

SD

[former_member204514 · Accepted solution]

Hi SD,

You can just multiply by 60 and calculate. It will result in minutes.

Regards,

aanand

[Former Member]

Hi Sebastian,

What is wrong with just using the 1st bit of your calculation FLOOR(Z_DURATION)*60

Does this not give you what you want?

Regards

Nick

[Former Member]

Apologies,

I meant to say Z_DURATION * 60

Regards

N

[Former Member]

Hi Nick..

I actually solved it myself using Z_DURTION * 60.

thanks anyway.