Enter Parameter Value (1 Viewer)

Hi,
When launching a query, I always get the 'Enter Parameter Value' popup for 'SumOfTotal_Paid_USD' and 'SumOfNumber_Boxes'. I have tried several fixes, but unfortunately, none is working for me. Can someone please help?
Thanks,
Susy

Hi. Try declaring their data types in the PARAMETERS clause. Just a thought...

You can't calculate and reference a field in the same query.

SumOfTotal_Paid_USD and SumOfNumber_Boxes do not exist until that query is run, therefore you can't use them in Expr1 of the same query to calculate a further value.

2 options:

1. Remove Expr1 from that query. Save that query as 'sub1'. Create a new query based on sub1 where you will be able to use the Expr1 calculation.

2. Use algebraic replacement to calculate Expr1---
Expr1: SUM(Total_Paid_USD) / SUM(Number_Boxes)