Hi guys/gals,

I'm creating a report and we basically want to change our decmial value according to the data in the table (So making it dynamic). We have a table called Decimal:

Measure    DecimalPlaces

Tonne       2
Grade       1
Dumps       3


So far everything works fine except a Crosstab. I did manage to create this:


if GridRowColumnValue("Measure") = "Tonne" then
    DecimalPlaces
Else
if GridRowColumnValue("Measure") = "Dumps" then
    DecimalPlaces
else
    0

That seems to work but the problem is the measure will be set up by the clients so some might have it as Tonne others as Tonnes and others just Ton. Is there a way to create a formula with an array or something so that it looks for that data and then uses the DecimalPlaces where it's found. Something like this:

If GridRowColumnValue("Measure" = (Search the Measure column and if there's a match) then
      DecimalPlaces
Else
      0


So it will kind of loop through the data of the Measure column and if there's a match to the Crosstab column value then it uses that amount of DecimalPlaces

Thanks for the response Lockwelle.

Problem is that some clients might not even have Tonne or use a totally different name for that measure. We need to make this 100% dynamically else it's not going to work at all.