topic Re: Numbers format in schedule in Project data & BIM

Numbers format in schedule

Tra — Wed, 11 Dec 2024 04:24:05 GMT

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

Re: Numbers format in schedule

vistasp — Thu, 12 Sep 2024 14:32:30 GMT

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

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

Re: Numbers format in schedule

Tra — Fri, 13 Sep 2024 01:50:29 GMT

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.

Re: Numbers format in schedule

vistasp — Fri, 13 Sep 2024 07:08:03 GMT

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:

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.

Re: Numbers format in schedule

Barry Kelly — Fri, 13 Sep 2024 07:24:29 GMT

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.

Re: Numbers format in schedule

Tra — Fri, 13 Sep 2024 09:59:19 GMT

Yes, You're right.

Re: Numbers format in schedule

vistasp — Sun, 15 Sep 2024 06:34:43 GMT

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