ray985 got a reaction from subraasingapore in Using external parameters in calculated field
Thanks. That did the trick.
For anyone else that has the same problem, here's the code I ended up using in the calculated field box. I passed the parameter "wattsaved" in the URL to Caspio which came from a textbox in my form.
CASE WHEN [@field:Per]='watt saved' THEN ([@field:Rebate] * '[@wattsaved]') WHEN [@field:Per]='kW saved' THEN ([@field:Rebate] * ('[@wattsaved]' / 1000)) ELSE 0 END