Formula in column works in testing but not in actual app

[fedeyobe]

Hello! how are you?

I need to calculate the amount that i have to pay to the cleaning staff on a weekly basis, so i've come up with a very complex formula that actually works.

The thing is it only works in a Virtual Column, not in a common column. And even with the VC it first gives a value and then changes after a few seconds.

If i test the formula on a common column it gives the correct result! i don't know why this could be happening.

The formula is the following: (i put it here for reference, but i don't think you need to analyze it)

sum(
select(registro_personal[monto_comision_personal_limpieza];
and(
in([id_personal];select(registro_reservas[id_personal];and(
in([id_reserva];[_THISROW].[Reservas del periodo analizado]);
isblank([Reserva vinculada]))));
in([id_personal];
select(registro_reservas[id_personal];
and(
in([lugar_reservado];select(registro_reservas[lugar_reservado];
in([id_reserva];[_THISROW].[Reservas del periodo analizado])));
in([lugar_reservado];select(lugar_reservado[id_lugar_reservado];
[Costo particular mano de obra por limpieza]=0));
isblank([Reserva vinculada])
)))))

+

select(lugar_reservado[Costo particular mano de obra por limpieza];
and(
in([id_lugar_reservado];
select(registro_reservas[lugar_reservado];
and(
in([id_reserva];[_THISROW].[Reservas del periodo analizado]);
isblank([Reserva vinculada]))
));
[Costo particular mano de obra por limpieza]<>0))
)

+ 

[Monto total limpiezas manuales]

Maybe it's because the fomula is too complex?. I want to put it in a common column because i don't want that it computes all the time in a VC.

Do you have any suggestions?

Regards,

Federico.