Forum Discussion
Multiple Variable Calulation
Hi there, I'm sorry to ask as I'm sure this is a standard query, but have been searching and trying for some time and can't quite get the answer to what I am trying to do. Please see some simpli...
Hi davidhh90 try to create calculated column with IF applying your logic, the same as in Excel. After that calculation or amount (creation of measure) should be very easy (based on your snapshop). Hope this help.
Hi some_bih thanks for the reply. I agree it should be a simple if formula and i've tried to do this in a calculated column. But I'm not sure how to make it lookup using the job field against those multiple variables at once. Currently, I can only see a way of doing it making multiple calculated columns for my 3 questions. Could you suggest the formula to use?
