Stop circular reference warning

Is there a way to stop the circular reference warnng from happening?

Basically my formulas depend on the value of D4 to where they are looking for the cell value, but my formulas return a circular reference warning, and this is the only way i can figure out exactly what i need. I dont want to add another cell(s) in my sheet and creat unecessary data just to resolve this

Is there a way?

In cell D14

Formula:

Please Login or Register  to view this content.

In cell D20

Formula:

Please Login or Register  to view this content.

Solved

Some of my data was summing the %'s, by multiplying the total by the second total, instead i changed it to sum totals and sum %'s, and this removed the circular reference