4 Replies Latest reply on Jul 5, 2010 1:51 PM by Frinholp

    Related Calculation Problem [Edit:debugging screenshots added]

    Frinholp

      Title

      Related Calculation Problem [Edit:debugging screenshots added]

      Post

      I cant seem to get a calculation to work. I have attached my relationship graph with this post.

      My problem is that on a layout based on Artworks I am able to show AcceptedArtistDetails::cCommissionDec and can also enter CommissionDetails::RequestedAmount which is entered through a related field on the layout. The Requested amount is used in a calculation which is a field within the Artworks table; all works fine. However I have tried to show the result of CommissionDetails::cCommission who's formula is RequestedAmount * AcceptedArtistDetails::cCommissionDec and nothing is displayed.

      I have tried storing the CommissionDetails::cCommission calculation as unstored and global.

      Screenshots of my calculation and debugging are uploaded to this link:

      http://img709.imageshack.us/g/dataviewer.jpg/

      Anybody any ideas?

      Thanks in advance

      Lee

      Relationships2.jpg