5 Replies Latest reply on Apr 21, 2010 10:05 AM by MarieB

    UnDP: Advanced Transform

      Hi

      We have several UPS'es from APC and Eltek Valere in our network, and I want to unify the display of remaining batterytime to a hh:mm format.

      Our APC UPS'es already report the remaining time in hh:mm, but the Eltek's report as minutes left. So I want to transform from, say 810 minutes to 13:30 (hh:mm), but cannot see that the formula field in UnDP lets me do this, and there are no ready-made functions for it.

      How can this be achieved?

        • Re: UnDP: Advanced Transform

          Hi Oyvind--

          Try this, where MinutesLeft is the name of the poller:

          Truncate(({MinutesLeft}/60),0):(Truncate((Truncate(({MinutesLeft}/60),4)-Truncate(({MinutesLeft}/60),0))*60),0))

          Thanks to Andrew Pacetti for this info.

          M

           

            • Re: UnDP: Advanced Transform

              Hi Marie

               

              I've tried using your suggested formula, but I get the error "Unbalanced parenthesis", and ****** if I can find out why.

              If splitting up the formula and testing, these two work on their own:

              Truncate(({MinutesLeft}/60),0)

              Truncate(({MinutesLeft}/60),4)-Truncate(({MinutesLeft}/60),0))*60

               

              However, this does not work:

              Truncate((Truncate(({MinutesLeft}/60),4)-Truncate(({MinutesLeft}/60),0))*60),0)

               

              I've double-checked the parenthesis, but I can't find where it fails, so if anyone has any suggestions, I'd be grateful.

               

              --

              øyvind