I have uploaded 3 simple csv files.
In my app
- the user makes selections from 4 dropdown fields. Each selection is then referenced in 2 csv files.
- 4 Number fields show the results from the above selections.
- 2 calculation fields then each multiply 2 of the results above together.
Everything above works.
Next I need to search for each resulting number from above in a 3rd csv & return the corresponding words. I cannot get this part to work. It seems that it is not possible to search for calculation results in reference data.
FYI, everything is on the same screen.