Forum Discussion

AhmadBakr's avatar
AhmadBakr
Icon for Helper IV rankHelper IV
2 years ago

Strange! Unclear circulrar reference

I have 2 calculated columns: Weeks Bin =  // calc col to order dispatch weeks in bins to prepare for a histogram     SWITCH(         TRUE(),         [dispatch weeks] <= 2 , "≤ 2"  ,         [di...
"Calculated Columns"
AhmadBakr's avatar
AhmadBakr
Icon for Helper IV rankHelper IV
2 years ago

I tried changing the difinition of the [Index] to be independent of [Weeks Bin], still got the same error. In the below [Weeks Bin] is not included in the calc col definition, yest same circular ref error!!!!!!!!
Index =

    SWITCH(
        TRUE(),
        [dispatch weeks] <= 2 ,  1,
        [dispatch weeks] <= 4 ,  2,
        [dispatch weeks] <= 6 ,  3,
        [dispatch weeks] <= 8 ,  4,
        [dispatch weeks] <= 10,  5,
        [dispatch weeks] <= 13,  6,
        [dispatch weeks] <= 26,  7,
        [dispatch weeks] <= 39,  8,
        [dispatch weeks] <= 52,  9,
        [dispatch weeks] >  52, 10
    )


I deleted both cols, defined only Index, went fine, defined [Weeks Bin] using a different col name 🙂 [Bin], still got a circular reference error to [Index]: "A circular dependency was detected: Stocks[Bin], Stocks[Index], Stocks[Bin]."