I can easily make a list of possible Zip Codes A and their distance from me in a spreadsheet. But how do I get Quatlrics to reference that and spit out a distance for me to use in embedded data calculations?
We're working on a LEEDs survey to measure the C02 Emissions incurred by respondents as they travel to our building. I need to take this distance and be able to multiply it by the number of trips the respondent takes in a week, multiplied by the C02 Emissions incurred by each method of transportation. Without Qualtrics doing half this work for me, I'm in for a really long analysis. But it definitely feels like something I should be able to use math operations for pretty easily if I can solve this "distance" problem.
Best answer by JenCX
View original