In a database containing numeric fields with names such as StWk950, I need to calculate fieldnames in a text list to produce a report showing the values contained in these fields.
This formula in the text list formula panel
results in this output in the text list
when the formula
fieldvalue("StWk"+fvWeek) produces the field name StWk950 (because fvWeek=950). This repeats the first record’s value of 203 in the whole text list, while the same fieldname StWk950 hardcoded outputs each record’s value correctly (203, 53, 46 etc).
Using a formula to calculate a fieldname does not seem to work properly in the text list formula although the same formula works correctly in other circumstances, for example in the formula workshop.
I have rewritten this formula in every possible way I can think of and the best I can do is to get the top record’s value repeated.