Solved

How do I output <null> in attribute table after calculation

Hello Sir / Madam,

So I would like to subtract both "Top Height" and "Rooflevel" attributes.

I use attribute manager to calculate the value

@round(@abs(@Value(TopHeight)-@Value(ROOFLEVEL)),1)

The result is shown as below.

However, I want my result to be <null> if either TopHeight or Rooflevel is <null>. May I ask how to do it?

Thank you.

Zachary

icon

Best answer by ctredinnick 13 May 2022, 09:53

Userlevel 3

+16

You can use a Conditional Value. It's in the dropdown when you set an attribute value in the AttributeManager, underneath 'Open Arithmetic Editor'

You can use a Conditional Value. It's in the dropdown when you set an attribute value in the AttributeManager, underneath 'Open Arithmetic Editor'

Got it! thank you so much for your prompt response! :)

Sign up