Hi All,
I would like to ask for some insights with a Circular Reference Issue. Here are the details
So we have a dimension Unit Mix, where the TOTAL is the Top Level and Parking and Total/ Average is the child. And under Total/Average are child member 1 BR, 2 BR, 3 BR, 4 BR. ( I hope i was able to illustrate the dimension properly).
The clients requirement is to calculate the Total/Average of the 4 Unit Mix without the Parking as they separate the calculation for this. What we are trying to calculate is the Total/Average for Flr Area and SP (Vat-ex).
Formula
Total/Average (Flr Area) = (Flr Area (Studio)*Unit(Studio)) + (Flr Area (1 BR) *Unit (1BR))+ (Flr Area(2BR)*Unit(2BR)) + (Flr Area (3BR))*Unit(3BR)) + Flr Area(4BR) * Unit *4BR)) /Unit(Total/Average
Total/Average (SP(VAT -ex))=(SP VAT-ex (Studio)*Unit(Studio)) + (SP VAT-ex (1 BR) *Unit (1BR))+ (SP VAT-ex(2BR)*Unit(2BR)) + (SP VAT-ex (3BR))*Unit(3BR)) + SP VAT-ex (4BR) * Unit *4BR)) /Unit(Total/Average
I tried to use Flr Area[select:Studio]*Units[select:Studio] and I got the Circular reference. I even tried to create a duplicate version of the module and refer it to that (since it worked in the past) but still getting the same error

Any ideas? Any help would be appreaciated
Regards,