Hai, I first time using power pivot, I have this error to lookup amount on other tab . Error message : the end of the input was reached. The calculated column 'cp[calculatedcolumn1]' contains a syntax error. provide a valid formula. what is this mean. thank you'