Skip to Content
avatar image
Former Member

xcelisus pie chart truncate value

Hi experts,

I am facing a issue to truncate mouse over values in xcelisus pie chart numeric value (1.61) to 1..

please guide in dashboard only ...

With Regards,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 15, 2017 at 07:20 AM

    Hi ,

    You can use truncate function in excel as below.

    Hope this helped you :)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 22, 2017 at 12:49 PM

    Hi ,

    Thanks for your help but in my system as I am using the BEX query so the data is not visible ..so how should I use this formula ..

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 27, 2017 at 08:54 AM

    Hi,

    Please use the formulae on the cell where you have binded the query.

    Let's say you have binded the bex query like the screen shot below.

    You can apply the formula in B cell . Please refer the screen shot below.

    I hope, It cleared your doubt.

    Add comment
    10|10000 characters needed characters exceeded