| |

VerySource

 Forgot password?
 Register
Search
View: 932|Reply: 4

editmask problem

[Copy link]

1

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-1-8 23:40:01
| Show all posts |Read mode
I want to change the display of a column (number type) in DW to ##, ## 0.00. For example, 4012354667.00 will be displayed as 4,01,23,54,667.00. That is one for the last 3 digits of the integer, and one for every 2 digits in the front. How can I achieve this? Thank you
Reply

Use magic Report

1

Threads

3

Posts

4.00

Credits

Newbie

Rank: 1

Credits
4.00

 China

Post time: 2020-1-16 18:09:01
| Show all posts
Set 000,000.00 in the format property, you can
Reply

Use magic Report

2

Threads

11

Posts

11.00

Credits

Newbie

Rank: 1

Credits
11.00

 China

Post time: 2020-1-17 10:54:01
| Show all posts
This should be fine
##, ##, ##, ##, ## 0.00

Put enough "##," in front of it.
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-1-17 14:36:01
| Show all posts
心系部落
This should be fine
##, ##, ##, ##, ## 0.00

Put enough "##," in front of it.

Not bad
Reply

Use magic Report

0

Threads

5

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 China

Post time: 2020-1-17 23:18:01
| Show all posts
Unless you can foresee how many digits are before the decimal
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list