asked on

Crystal Syntax in Formula Editor for passing a Parameter Field to a calculation of two fields where the Parameter is only part of one of the field names in the calculation

I wish to add the value of to fields together. e.g.
{Balance} + {Value@1}

The fields available in the table = {Balance}, {Value@1],{Value@2],{Value@3],{Value@4],{Value@5],{Value@6],{Value@7],{Value@8],{Value@9],{Value@10]

But I have a Parameter that allows the user to inter a number value 1 to 10 for the purpose of selecting the correct Value field.
E.g.
Prompt = "Enter Value Number"
User returns 4
Therefore the calculation should = {Balance} + {Value@4}

Ideally If my Parameter was called "UserValue" then my formula would look like this:
{Balance} + {Value@{?UserValue}}

Please help me understand where my syntax is wrong.

Thanks
MC

ASKER CERTIFIED SOLUTION

analliah

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

analliah

if you parameter value is = to your table value,
then just create a formula @p_formula
{?parameter}

on you existing formula it would be
{Balance} + @p_formula

Mchallinor

ASKER

Ok, I accept that your answer maybe a possibility.

I was curious about the naming of the field by the developer.
The field name is Value@1
When you hover the cursor over this field it shows a tip [Value](number)
In a database viewer the field title is called Value[1]

It seems to me that there is a stored value and you can pass a (number) to it to select the Value stored at that number?

Sorry if this sounds confusing.

Mike McCracken

If it is an array then you could use the parameter as an index.

Value[?Parameter}]

I suspect thought that the field name in the database or the view is Value[1]

mlmcc

Mchallinor

ASKER

No sorry that doesn't work.

I agree with your thoughts, I thought it was an array field, but perhaps it is not.

I think first suggestion by analliah is what I need to use.
Thanks