Calculation using Bridge Table

[Anonymous]

Hey I have created a bridge table .Now i am uanle to sort out following calculation:

IF(VW_DETBRKG1[Breakage Date]>VW_DETJOBM4_2[INIT_DATE],"yes","No")

I tried using lookup but it throws cicular dependancy error.

[v-xiaotang]

Hi @Anonymous 

Thanks for reaching out to us.

could you share some sample data for us to check if thay way is possible? thanks

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

@Anonymous 

i think you are lookupvalue from many side to another many side?

not sure if you can get the correct answer.

you can try 

maxx(filter(vm1, vm1[jobno]=vm2[jobno]),date)