Calculated Field shows value in Layout but Export shows 0
I have table A with a calc field (number) that retrieves a sum from related table B. So as not to have empty values i have written it this way.
Sum ( PRISM | Transactions | PV::Cost_Transaction ) = 0 ; 0 ; Sum ( PRISM | Transactions | PV::Cost_Transaction )
I have a layout displaying the fields for table A. I can view them and export this xlsx file for this particular field using FM Pro 12 with no problems. I have a script running from FMServer at 1am that essentially exports this data as i do manually in FM Pro however but all my 1200 or so records show 0 down this field. Any one experiencing this as well?