[Troy DeGroot]

I know you have to have the parameters listed in the order of operations, but it looks like you already have that correct. What happens when you delete them and start over? I’ve had to do that from time to time.

I’ve also seen some weird things in the latest update. Legends not reporting, text editing in a custom column. Could be a bug messing with several functions.

[Doug McLean]

the dreaded Excel #Value error

[Doug McLean]

Does it matter that one is Text and one is a Formula?

[Chris Riley]

Doesn’t seem to matter. I first created it as a text and was changing it to formula. I deleted it and then added it again as a formula and still get the same error.

[Vince]

I think I may have come across something like this in the past – it was something to do with already having referred to the column in another formula i.e. you can’t refer to the same custom column twice. Well I think that was the issue – it was quite a while ago when I tried to use the formulas in Revu!

[David Cutler]

That sounds as if it would be incredibly limiting @Vince – and probably very frustrating!

[Vince]

I gave up on using the formulas in Revu when creating my first setup – that was for measuring roof timbers.

[Doug McLean]

they are pretty limiting

[Chris Riley]

Yeah this would be incredibly limiting. If you can’t re-use a variable then the variable list would get very long.

[Isaac Harned]

I may be under complicating this, but I did three custom columns, one for input and the other two referencing the value, it seems to work ok on my end.

[Chris Riley]

Some how I had 2 columns that had the same name, neither of which I was using for the particular formula I was writing, but I deleted one and I think it may have solved my problem. Have not had time to do some more in depth testing, so stay tuned…