Perform SUM Calculation within PDF Report

AppSheet AppSheet Q&A
, ,
1

Hi All, I have created a PDF report which details vehicle movements. The PDF Report works well but I would like to look at performing SUM calculations within the report to improve MI but can’t quite work out how.

<<COUNT(FILTER(“Vehicle Movements”, AND ([Searched]=”Yes”,[Date Time]>TODAY())))>>

<<COUNT(FILTER(“Vehicle Movements”, AND ([Searched]=”No”,[Date Time]>TODAY())))>>

These are two items I have within the report (There are more). I would like to perform a division sum within the report. I’ve tried the following:

<<SUM(COUNT(FILTER(“Vehicle Movements”, AND ([Searched]=”Yes”,[Date Time]>TODAY())))/COUNT(FILTER(“Vehicle Movements”, AND ([Searched]=”No”,[Date Time]>TODAY()))))>>

but it says SUM is used incorrectly.

2

Test:
<<COUNT(FILTER(“Vehicle Movements”, AND ([Searched]=”Yes”,[Date Time]>TODAY()))) + COUNT(FILTER(“Vehicle Movements”, AND ([Searched]=”No ”,[Date Time]>TODAY())))>>

3

The Addition works absolutely fine but when performing a division it returns 0(Zero). I think it is because it is not a full number but a decimal. So trying to perform a percentage calculation (A / B * 100).

4

Test:
Try circling the parameters of the DECIMAL(…) function

DECIMAL(A)/DECIMAL(B)*100

5

That my friend works perfectly! Your a Steely Eyed Missile Man! Thank you.

1 Like