Calculating Cross Currency Rates (by creating a fixed variable)

Thanks for your reply - That's what I would like to do, but I don't know how.

My report is very simple, please see below.

Thanks!

ONE LINE OF VARIABLES:

Curr Date @FX_Per_CAD

Which will list all the currency rates that are in the system for that date.

@FX_Per_CAD Formula:

if {vrcFX_SpotRate.Curr} <> "CAD" then
Round (({vrcFX_SpotRate.Bid} ^ (-{vrcFX_SpotRate.Factor}) * {@CAD Rate}), 7)
else 1

@CAD Rate Formula:

if {vrcFX_SpotRate.Curr} = "CAD" then {vrcFX_SpotRate.Bid}
else 1

My formulas do not work because the report looks at each rate individually, so it cannot divide two rates. I need to somehow make a parameter equal to the CAD rate throughout the entire report, so that rate can be used alongside other rates.

Thanks again!