How to get a field value

[danielcmr]

Hello.



In the image, I have the blue fields working as I want, the green field too (is the sum of the blue fields), but I can't get the red field to work. It should give the sum of all green fields. Can anyone help, please?

Many thanks.

[danielcmr]

I finaly came with the soluction of calculate de red field all alone, with DLookups, not depending of the other ones. For now seems to work.

Thanks guys.