Related Calculation Problem

[frinholp]

I cant seem to get a caculation 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 attached too.

Anybody any ideas

Thanks in advance

Lee

Edited July 5, 2010 by Guest
Added debugging info

[bruceR]

Look at the result type; it's a global. It should be an unstored calc.

[frinholp]

Thanks Bruce

I have tried having the calculation unstored. Changing the result to Global was a last ditch attempt to get the calculation to work. It just so happens to be that the screenshot I took was after I tried that. Sorry for any confusion.

I have also tried changing the field cCommissionDec to a non-calculated field with a constant number....still no joy.

If I have the calculation stored in Artworks everything works fine. I'd rather not hold the calculation there as I would like to conditionally lock the CommissionDetails table using privileges.

Any ideas?