3 Replies Latest reply on Oct 11, 2013 8:52 PM by DomingoUgarte

    Calculated Field shows value in Layout but Export shows 0

    DomingoUgarte

      Title

      Calculated Field shows value in Layout but Export shows 0

      Your post

           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.

           Case (

           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?
            
            
            

      10-11-2013_3-48-10_PM.jpg