Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to show the percent symbol in output.

  1. #1
    Join Date
    Aug 2011
    Posts
    10

    Default How to show the percent symbol in output.

    I'm doing a simple transformation.

    Table input -> Formula -> Join -> Execure SQL (Output)

    This is my formula.

    IF ([lastsalesytd] = 0;0.00;(([lastsalesytd] - [lastcostytd]) / [lastsalesytd] ) )

    I have a Value type of number.

    It' get's outputted as a decimal, I need percent. I've in the past tried all types to tricks in the formula, but I'm trying to revisit this issue to see if someone has come up with anything new.

    Thanks in advance.

  2. #2
    Join Date
    Mar 2011
    Posts
    257

    Default

    after you have calculated your value you will have to change it to a string and concatenate a % sign to it.
    because a % sign is not a decimal number but a string.

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.