xcelisus pie chart truncate value

[former_member267487]

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,

[Former Member]

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.

[former_member267487]

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,

[Former Member]

Hi ,

You can use truncate function in excel as below.

Hope this helped you 🙂