I have a calculated field in a table with a calculation like " All¶ -¶" & ValueListitems ( “” ; “ValueList_A” ). It works when Filemaker file resides in a local computer, with calculation results stored or unstored. However, if the file has been uploaded to the server and the above calculated field is created after upload, the same field calculation will fail with a “?” if calculation result is stored. However, it will be successful only if it is unstored.
I need the result to be stored, so that I can create another value list from this calculated field. Is there any work around, or had I committed any mistake in the process?