Here is my setup:
I have 2 tables join by one field named "Res" ,
in table 2 I have 2 calculation fields, one named 'rf' containing 'table1:Res' and the other Named 'Sort' containing 'If(table2:Res = rf; 1; 2)'.
This is displayed in a layout where I have the field 'table1:Department' and 'table1:Res' and in this layout I have a portal where I have the 'table2:Department', 'Sort' and 'rf'.
When I change the Department in layout the 'rf' calculation in portal is updated but not the 'Sort' ?