AnsweredAssumed Answered

Can not filter my portal using a calculation (number) field

Question asked by IanLenehan on May 28, 2012
Latest reply on May 29, 2012 by IanLenehan


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.

Many Thanks