Hi,I have two tables, in the Pallet_Information table I have the result field, and in the Report table I have the Final Result field; The result of all my records from the Pallet_Information table is averaged and the Final result for the Report table...

Hi,I have a table where I want to take the average of 3 values in percentage format. In my Google Sheet I have the formula which calculates what I want, but when I pass it to AppSheet I can't.=IF(Y12=0,"",100%-AVERAGE(Y12:Y14))Y12 =3.3 %Y13=6.7 %Y14=...

Hello,I have two tables PALLET_INFORMATION and REPORT, within PALLET_INFORMATION I have a field that is Scar% where I want the result of dividing a value within REPORT called SCARS-RUSSETING of type number between the Size value that is in the REPORT...