Hi everyone, I am trying to use AVERAGE in a gallery, but its showing only the first number in the table not averaging the column. The code is Average(LookUp('Depot-LineItems',crd63_partorderedname = ThisItem.cr3db_crd63_partname).ARRepairCostTotal).
Depot-LineItems is a table where I record repairs to items, and the table Depot-Parent is where the parts are listed.
Any help would be amazing, thank you!! Ive never used AVERAGE before.
Chris