N/A results on a Building Take-off worksheet

Chris JAP · February 21, 2022

Hi,

I have set up a building take-off worksheet on vectors.

I have set up a database for 'wall types' and added 'wall style' and 'wall area NET' functions.

However the results provide a mixture of numerical values and N/A.

What creates these N/A results and how can i get rid of them?

Picture attached.

Best,

Chris

Pat Stanford · February 21, 2022

NA shows when the object in that database subrow does not have the record specified in that column attached.

This was a new changes in VW2022. Before it would just show blanks.

You will need to modify your formulas to use an IFNA function.

=IFNA(your original record.field, 'what you want if the return is NA')

Put whatever you want between the single quotes to be returned instead of NA. Or just put the two single quotes to return blank.

=IFNA(WALLAREA_NET, '---') will give you three dashes if the object does not have a WallArea_Net and the area if it does.

Question