My PowerPivot formula works on individual components but combination gives error
Posted on 2014-10-08
I try to create a formula in Power Pivot, where I try to generate a new column (or even better a measure if anybody can help on that
=mid([Placement],11,1) returns correctly the 11th character, if the [Placement] column has characters
=if(len([Placement])>0,1,2) returns correctly either 1 or 2 dependent on the length of [Placement]
But combining the two into one new Column like below generates an error
Urgent help is needed.