Can not filter my portal using a calculation (number) field
I have a FM Pro 12 database where I am trying to filter a portal by a calculated field, however it doesn't seem to be working. The calculated field is calculating the difference between two numbers, and when I put the result into the portal, is displayed as I would expect it to.
The calculation for this field (Depot_PORTAL DATA::Total Outstanding) is: Total Outstanding - Count (Portal Completed::Barcode Up). It is also set to display as a number, which it does.
The filter I have applied to the portal is Depot_PORTAL DATA::Total Outstanding > "0". I have also tried Depot_PORTAL DATA::Total Outstanding > 0
However my portal does not exclude results with 0 in this calculated field.
Any suggestions as to what I may be doing wrong would be greatly appreciated. I did search the forum for a similar issue but couldn't find anything.