You can search the index of a value with the FPScript function SearchValue. With FPScript you cannot directly manipulate a data set. In this case you have to write a VBA macro. But the formula can return the new calculated values.
data = dataset
data[SearchValue(data, -3.40282e+038)] = ?
In FlexPro 7 a FPScript formula can return a list with the datasets. In FlexPro 6 you need a formula for each data set.
In this case it’s better to create a VBA macro with FlexPro Professional. With FlexPro Standard you cannot automate these steps.
Do these steps:
1) Create the formula ‘ReplaceValue’ with the arguments data and value which replaces the value with ‘?’.
Arguments data, value
dd = data
dd[SearchValue(dd, value)] = ?
2) Write a macro which creates one formula for each dataset.
With VBA you can also convert (evaluate) these formulas into a dataset and delete the origin data sets.