Dear all,

I am making a model that should contain a lot of input columns, but we might delete some of them afterwards. Assume I have columns like this:

Score 1 - Weight 1 - Score 2 - Weight 2 - Score 3 - Weight 3 - Final score

Now I multiply each score with its weight and add them all up in column 'Final score'.

If at the end, I want to delete columns Score 3 and Weight 3, my formula breaks down (#REF). Does anyone know a solution for this?

Thanks and regards,

Juriaan.