Hi - Please see the screenshot before you start reading my question. The formula that I have derived in the field organizer works perfectly in the Add Formula screen (circled in red) but doesn't seem to work in the Field Organiser TAB (circled in Blue). Could you please help me to fix this issue. Thanks
I received your file, thank you. I can't reproduce this. Using the input block's 10 rows of preview data as a source, the formula evaluates correctly inside the block.
Please try the following:
Install the latest version of 2.7, currently 2.7 b272
In the DataManager view, choose "Tools > Clear disk cache"
In both "Marin FO" block and the block above it, choose "Block options (wrench/spanner icon) > Update data"
Check the "Marin FO" preview data. If the formula still isn't being calculated correctly, in the same Omniscope session, choose "Help > Error reporting > Report a problem" and write "FAO Steve - Formula not working".
Alternatively please email to arrange a Join.me session.