How to cut last 3 characters from a table?

[Former Member]

Hello alltogether,

I've got the following issue.

I've got table with values from Jan-Dec. The values are about billions...

In the formula editor I already divided the values locally in WebI through a 1,000,000.

Example:

I've got a value 658,971,018.04 --> will result 658,97

What I wanna do know is to cut the last three values so the table shows only the value 658???

Can you help me how to solve the issue?

Thanks a lot!

[Former Member · Accepted solution]

Hi Jema,

1 Select the Column which you want to format

2.Right click "Format"

3.Go to Format type Choose"Number" and check the Custom Checkbox

4.Now you choose it as per your requirement

[Former Member]

Hello Jema,

Create a variable like below:

=Left(FormatNumber([value];"###");Length(FormatNumber([value];"###"))-3)

It will cut the last three digits as required.

Regards,

Madhumitha

[Former Member]

Hi Jema,

       if your requirement is to display the first 3 char, then you can use the below formula and no need to divide by 1,000,000.

Formula:

=Left(FormatNumber([Sales revenue];"###");3)

Thanks.

[Former Member]

Hello you two,

thanks a lot for your quick and helpful respond!

Regards

[Former Member]

Hi ,

Convert the number to string format using formatnumber() function.

then extract the first 3 characters using substr() function.

Now if you wish to see result in numeric format , then use tonumber() function.

Hope this helps.

Thanks,

Niranjan