Well, that's actually my fault because there is more to the lab and I probably left some crucial things out - sorry about that!
Luckily, I did what you said and it gave me the result I was looking for. Thank you so much!
My instructions are as follows:
"In the fourth column of the design grid, create a new field named Sponsor Donation that will calculate and display the donation amount when the Sponsor donates an amount equal to 50 percent (0.5) of each box office receipts amount to the Music Department."
I've...