Calculated Value

[ennujozlagam]

Hi, Maybe you can help me with this I created calculated value Plot Ratio (Gross Floor Area/Site Area = Plot Ratio) but it come out result is "0". Any reason why it didnt calculted properly or what is the correct formula to achieve the coreect answers?

Please see Attached.

Thank you

[Alfredo_Medina]

That's strange. The formula is correct, and the type of data (number) is correct. I made a test with the same values, and I obtained a result, as shown in this image. There must be some other setting in your project causing this, but that is difficult to determine without seeing the file.

[ennujozlagam]

Hi Alfredo,

Thank you for your reply, How are you going to access my file and how can you help me?

Thank you.

[Alfredo_Medina]

If you can post here a reduced, simplified, purged, version of your file showing that schedule, go ahead.

[ennujozlagam]

Hi Alfredo,

Thank you, I deleted the building structure but left the area, area tags and boundary lines because of the confidentiality of the projects im sorry about that.

i also attached screen shot because i cannot create Area Plan for " Site Area". What i did i used the road level then rename it as site plan, i dont know if this is correct?

Please see attached.

Thank you.

[Alfredo_Medina]

Plot ratio is = Gross Floor Area / Site Area , and Gross Floor Area has its own formula, which is if(Site, Area, 0 m²).

Site is a yes/no parameter, which at the moment is null, meaning not yes, nor no.

Solution: turn Site to be On, so that Gross Floor Area can take the value of Area, and therefore, Plot Ratio can obtain a value, too.

[ennujozlagam]

Hi Alfredo,

Thank you for your reply, I Followed your instruction. But it seems like doesnt work (please see attached)

My total Gross floor area is the combinaation of from 1st storey to Lift motor room (Can seeit my posted RVT file.)

Total GFA is combination of "Production + Ancillary + Other Ancillary + Ancillary Office = Gross Floor Area"

Thank you

[ennujozlagam]

Continue Attachment...

[aghis_no · Accepted solution]

If I understad well you must have several "area"s that form you global "gross area". And from the images you sent, i presume that, in order to have the global "gross area" you have probably unchecked the "itemize every instance" on the "sorting/grouping" tab of the schedule properties.

I suggest (in order to have the formula working) to try going to the "formating" tab of the schedule properties and check the "calculate totals" for each field concerned by the formula.

Hope this will work

aghis

[Alfredo_Medina · Accepted solution]

Your initial question was about the "Plot Ratio" parameter not reporting any value. I have explained that it shows 0 because there is a Yes/No parameter that is NULL. Set that value to YES, and the Plot Ratio will start reporting a value. That's all. It seems that you are expanding the topic of your question to many other topics and detailes of your project that I am not familiar with.

[ennujozlagam]

Hi Alfredo,

Thank you very much for your help. I think i had already done what ever you suggested in your last posted anwers, but it seem the result is still the same.

Please find attached.

Regards.