Pricing Layer - second layer is a % of the first

I have a group of 47 performances. Each performance has a different adult price. I need to create a price layer that is 10% of the adult price. I've tried adding the second layer and copy/paste special from the first layer but it's not working.

Is there anyway to accomplish this without having to manually calculate the 10% for each of the 47 performances?