Forum Discussion

MilanAXVII's avatar
MilanAXVII
Helper I
8 years ago
Solved

circular dependency was detected

A circular dependency was detected: timbratura[time FG mancante log], timbratura[FG mancante log], timbratura[time FG mancante log].

 

I already write a formula to find a count with this formula

FG mancante log = calculate(COUNTROWS(timbratura);FILTER(FG;FG[Sintomi L3]="MANCANTE"); FILTER(FG;FG[Team Provenienza]="LOGISTICA");FILTER(FG;OR(FG[Descrizione Difetto]="GO";FG[Descrizione Difetto]="STOP")))

 

But i want now the sum of time

 

time FG mancante log = calculate(SUM(timbratura[tempo FG]);FILTER(FG;FG[Sintomi L3]="MANCANTE"); FILTER(FG;FG[Team Provenienza]="LOGISTICA");FILTER(FG;OR(FG[Descrizione Difetto]="GO";FG[Descrizione Difetto]="STOP")))

but there is a pb. someone know why?

  • I can only speculate but it seems like perhaps timbratura[tempo FG] might somehow reference timbratura[FG mancante log]?

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    I can only speculate but it seems like perhaps timbratura[tempo FG] might somehow reference timbratura[FG mancante log]?

  • Ajithkumar's avatar
    Ajithkumar
    Regular Visitor

    Same issue How to Solve 

     

    A circular dependency was detected: s[Available mins Batch], s[EARNED MINS BATCH], s[Available mins Batch].