try sent * Sum ( color::sheets )
Thanks for your help Evan Rawson,
I've tried what you said, but now it comes out literally as a sum of all *sheets*
Sorry I misunderstood your original post. I thought you were talking about the Total values at the top of the screen. Please change the calculations back to what you had originally.
I believe your issue is actually being caused by the table occurrence that your portal is based on. Is your portal based on the Color table occurrence? If so, change it to the Production Shipping table occurrence.