Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Formula editor, Percentages and Limiting the returned 'Scale'

  1. #1
    Join Date
    May 2017
    Posts
    20

    Default Formula editor, Percentages and Limiting the returned 'Scale'

    Hey all,

    ... so here is my formula:

    =CONCATENATE(SUM(([SumFunction1]/[SumFunction2]) * 100) & "%")

    This works... and returns 123.45978967654%

    What I would like it to return is: 123.460%

    I would like to return three places to the right of the decimal, rounding up to the thousandth, AND if the 3rd digit is a 0, display that as well.

    213.456%
    123.450%
    123.000%

    Any assistance on with my formula would be greatly appreciated.

    Thanks
    Iowabeef

  2. #2
    Join Date
    May 2017
    Posts
    20

    Default

    Solved it myself...

    just had to publicly admit I didn't know, THEN and only then could I actually find my own solution.

    If anyone else has this issue, try this:

    =CONCATENATE(FIXED([SumFunction1]/[SumFunction2] * 100;3) & "%")

    Thanks all... I'll be back when I really need help.
    Iowabeef

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.