topic Re: Adding Formula in Zone Scheme in Collaboration with other software

Adding Formula in Zone Scheme

Anonymous — Wed, 14 May 2014 19:47:35 GMT

Hi,

I am currently exploring the use of scheme, especially the zone scheme to get the custom zone list. The techniques is quite manageable.
The question is, Can we create a formulated cell?
For instance, I have list of rooms that are sorted by categories. Then, I want to add a custom column which contents of percentage/ratio of them, which is driven by the calculated area.
Is it possible?

Re: Adding Formula in Zone Scheme

Barry Kelly — Thu, 15 May 2014 03:19:11 GMT

Formulae in cells are not possible (other than the simple SUM totals.
You will need to export you schedule and do the calculations in Excel (or similar).

Barry.

Re: Adding Formula in Zone Scheme

Anonymous — Thu, 15 May 2014 03:23:56 GMT

Thanks Barry,

I thought so, it is only strings in custom text field.
Perhaps I should list it in Wishes forum.

Cheers.

Re: Adding Formula in Zone Scheme

Barry Kelly — Thu, 15 May 2014 03:42:15 GMT

This has been wanted by many people for years.
Although I just did a quick search of the wishes section and didn't find one relating to schedules and calculations.
I'm sure there is at least one there somewhere but feel free to create a new one - I'll vote for it.

Barry.

Re: Adding Formula in Zone Scheme

Electric Flute — Wed, 04 Jun 2014 20:38:19 GMT

Barry wrote:
feel free to create a new one - I'll vote for it.

I also vote for it!!