You can use a parameter combined with a case statement calculated field:
Case [TimeSeries Parameter]
when 'TimeSeries A' then [TimeSeries A]
when 'TimeSeries B' then [TimeSeries B]
Thanks for the reply. So where/how do I do the actual calculation? I want to filter the [STRIKE] parameter and have it perform the calculations above....how will the CASE know which strike is TimeSeries A, Timeseries B, etc...
I tried the following:
WHEN '1950' THEN [Strike1]
WHEN '2000' THEN [Strike2]
WHEN '2050' THEN [Strike3]
[Strike1] - (2*[Strike2]) + [Strike3]
The error states Strike1,2,3 is undefined field?
Thanks for your assistance!
Any help on this would be really really appreciated!!