topic Re: Problems with IFS based Expressions in Project data & BIM

Problems with IFS based Expressions

Jeff Galbraith — Thu, 23 May 2024 14:08:56 GMT

I'm getting unpredictable results using the IF and IFS functions. No matter how I write the expressions there are always some objects that return an 'undefined' output. What you'll notice in the schedule above is that 5 objects have the 'N/A' value in the first column, but only one of them returns the correct result of 0.00. The others all say <Undefined>. If I change the value int eh first column to either of the other 2 options (UNIT of LENGTH) then I get the right result...no more 'undefined'. Any Idea what's going on here?

I've also tried writing these expressions many different ways. I've tried writing them all into one IF expression, but that would only give me one correct result, the other 2 inputs would result in 'undefined', and it changed depending on what order I put them in.

Operating system used: Mac Apple Silicon 14.5 Sonoma

Re: Problems with IFS based Expressions

Laszlo Nagy — Thu, 23 May 2024 14:12:07 GMT

Try to consolidate those three separate lines of IFS expressions into a single IFS expression. You just use commas to separate the different cases.

See if that works.

The purpose is to have a single expression that covers all possible values so a value is always assigned to the Property.

Re: Problems with IFS based Expressions

Ricardo Lopez — Thu, 23 May 2024 17:10:57 GMT