min($(variable))

[#1]

Hi,

I have 4 pricing columns associated to a material

Is it possible to define a field name in a variable, and then use the variable in formulas

ie

vPrice = 1

vSalesPrice = 'SalePrice' & $(vPrice)

in reports,

sum($(vSalesPrice))

which would then return one of the 4 pricing columns, depending on the vPrice variable value?

Currently have 4 separate expressions, using a conditional show based off vPrice, but was hoping to combine to just the one expression

Please advise,

Kind regards,

Rich

[sunny_talwar · Accepted solution]

How about this:

Sum($(='SalePrice' & $(vPrice)))

[#3]

many thanks Sunny!

[effinty2112]

Hi richard,

          Have a go with:

=Sum([$(='SalesPrice' & '$(vPrice)')])

the square brackets are not necessary her but would be if you used this with a field name that has a space.

Cheers

Andrew