1 Reply Latest reply: Oct 25, 2012 9:57 AM by 597001 RSS

    xdofx:ceil on xml publisher

    user469514
      Guys

      i am not able to ceil on the below, could some one let me know if this is possibile

      eg..
      <?sum(current-group()/PALLET)?> -- gives 43.34

      <?xdofx:ceil(sum(current-group()/PALLET))?> i want to give as 44

      Thanks

      Edited by: user469514 on Oct 24, 2012 8:50 PM
        • 1. Re: xdofx:ceil on xml publisher
          597001
          Use round instead
          <?sum(current-group()/PALLET)?> -- gives 43.34
          <?xdofx:ceil(sum(current-group()/PALLET))?> i want to give as 44>
          <?xdofx:round(sum(current-group()/PALLET))?>
          Please remember below
          Note: You cannot mix xdofx statements with XSL expressions in the same context. For example, assume you had two elements, FIRST_NAME and LAST_NAME that you wanted to concatenate into a 30-character field and right pad the field with the character "x", you could NOT use the following:

          However, you can take this value into variable do a ceil.

          Refer the below link for supported XDOFX functions
          http://docs.oracle.com/cd/E10415_01/doc/bi.1013/e12187/T421739T481158.htm
          ND
          Use the "helpful" or "correct" buttons to award points to replies / Mark the thread as answered, if your question is answered.