I am trying to perform a mathematical formula on a Roll Up Field. Specifically I have…
- A bunch of records on Table A with FIELD ONE = (Float)
- On Table B I take an Average of the value of FIELD ONE s on Table A which I am doing using a Roll Up Field. This field with be named FIELD TWO.
- On Table C I would like to lookup the FIELD TWO from Table B and then multiply it by a factor of 1.2. Whenever I try to do this, every cell prints #ERROR!.
I have tried using a Lookup Field and various types of Average/ Array Field Formats.
I have also tried to use the “value()” function in my formula on Table C however it is not working.
Does anyone know how to make this work?