Circular Reference issue

Hi All,

 

Please see attachment for details. My apologies my post encountered an error so I have to attach the details

 

Regards,

Best Answer

  • Answer ✓

    @Jsdeloria21 

     

    It doesn't look like a composite hierarchy. So I would say lets create a subset of all Total/Average and ignore Parking portion from the list just to be on the safer side

    Misbah_0-1593174104840.png

    Once you create a subset create below module. I created additional two line items so that they help me in getting me the correct output at top level by having RATIO at the summary level

    Misbah_1-1593174562996.png

    Misbah_2-1593174666764.png

    Misbah_3-1593174694946.png

    Misbah_4-1593174715976.png

     

    Hope I got the requirement correct and hope that it helps

    Misbah

     

     

Answers

  • Hi @Jsdeloria21,

     

    Can you clarify my doubts so that i will analyse your problem well.

     

    1. i assume Flr Area, units, SP(VAT -ex) are line items and Unit Mix is a dimension of a module.

     

    2. 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

     

    is it a formula written on Flr Area line item...?

     

    3. 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

     

    is it a formula written on SP(VAT -ex) line item...?

     

    4. I tried to use Flr Area[select:Studio]*Units[select:Studio] and I got the Circular reference

     

    in which module are you writing this formula..?

    and what is the line item name...?

     

    Thanks,

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In