cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 
Project data & BIM
About BIM-based management of attributes, schedules, templates, favorites, hotlinks, projects in general, quality assurance, etc.

Numbers format in schedule

Tra
Participant

Hi All, I have a few questions regarding the cell format in the schedule.

1. is there a way to add a thousand separator "," to all the numbers in price column?

2. is it possible to add a dollar sign icon?

3. Can we input the words "grand total" in  the cell before the 122186.

 

Thanks so much.

 

Operating system used: Windows 10


t1.jpg
6 REPLIES 6
vistasp
Advisor

Digit grouping and the $ sign should be possible using Properties.

 

I don't know of any way to add the words Grand Total, though.

= v i s t a s p =
bT Square Peg
https://archicadstuff.blogspot.com
https://www.btsquarepeg.com
| AC 9-27 INT | Win11 | Ryzen 5700 | 32 GB | RTX 3050 |

Thanks for your response, But I still don't quite understand. I've already set the digit grouping in the windows control panel, but I still can't add the dollar sign and separator in Archicad.

13.jpg

12.jpg

vistasp
Advisor

Digit grouping from your OS won't help here.

 

You'll have to use the Property Manager and create a new property which does what you want. This property can then be inserted into the schedule in place of the price information for the element.

 

As an example:

 

vistasp_0-1726208126815.png

 

I don't know of an easy way to split the price data for inserting the commas, but maybe someone who has already done so will chime in.

= v i s t a s p =
bT Square Peg
https://archicadstuff.blogspot.com
https://www.btsquarepeg.com
| AC 9-27 INT | Win11 | Ryzen 5700 | 32 GB | RTX 3050 |

The problem with creating a property to show $ symbol, is it will now be a string and it won't total in the schedule.

I would just live with "$" in the column/row title which you can customise to say what ever you want.

 

Barry.

One of the forum moderators.
Versions 6.5 to 27
i7-10700 @ 2.9Ghz, 32GB ram, GeForce RTX 2060 (6GB), Windows 10
Lenovo Thinkpad - i7-1270P 2.20 GHz, 32GB RAM, Nvidia T550, Windows 11

Yes, You're right. 

Yes, I didn't think of that. Which shows how little I use Properties. 😅

= v i s t a s p =
bT Square Peg
https://archicadstuff.blogspot.com
https://www.btsquarepeg.com
| AC 9-27 INT | Win11 | Ryzen 5700 | 32 GB | RTX 3050 |

Setup info provided by author