Skip to Content
avatar image
Former Member

Formula (Mathematical Function) implementation in BEx 7.0

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 02, 2008 at 10:56 AM

    Hi SD,

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

    Regards,

    aanand

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 09:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded