Leave feedback
  • Question

    Advanced Formatting In Bar Graph Value

Enter a new topic
  • Nikhil Bansal Nikhil Bansal
    0 likes 1728 views

    Hi,

    I am using SP4 R1.

    I am using advanced formatting in bar graph value.

    I'm using the format as num.currency{} which has format of $10.00

     

    But I require format as $10 without two decimal point, how should i achieve this??

    Can i modify num.currency{} ??

     

    I'am unable to append $ as string in the bar chart value as it is gives bad lexical error because it plots the bar on the basis of this value??

     

    Please suggest a way to resolve this issue??

     

     

    Thanks and regards,

    Nikhil Bansal

     

     

     

    Saturday 10 March, 2012
  • Best Answer
    Nikhil Bansal Nikhil Bansal
    0 likes

    Hi,

    I have done it as text{$sz,zz9} and it works.

    Regards,

    Nikhil 

    Saturday 10 March, 2012
  • Vyv Lomax Vyv Lomax Administrator
    0 likes

    Check out this similar post.

    Saturday 10 March, 2012
  • Nikhil Bansal Nikhil Bansal
    0 likes

    Hi Vyv,

    Where Can I specify this format?? In the tool or before script of chart??

    IS there any manual to check how to modify things??

    I want to change $10.00 to $10

     

    thanks and regards,

    Nikhil

    Saturday 10 March, 2012
  • Vyv Lomax Vyv Lomax Administrator
    0 likes

    See attached.

    Have you tried num.integer?

    Saturday 10 March, 2012

    Attached files

  • Nikhil Bansal Nikhil Bansal
    0 likes

    Hi,

    I have done it as text{$sz,zz9} and it works.

    Regards,

    Nikhil 

    Saturday 10 March, 2012