[userg19]

ON SQL if there is possible to get Five Different ID on One product i have a code but nothing appears or i have something missing in my SQL



" Select IFNULL(format(sum(Amount),2),0) from tblsalesperformance where CustomerID ("","","","","") and YearCode = '2021' and MonthCodeint >= @@text0000000097 and ProductID = @#dropdown0000000005 "

ON my 2022 is a single ID but only one Customer
" Select IFNULL(format(sum(Amount),2),0) From tblsalesperformanceproduct Where UserID = @@text0000000085 and CustomerID = @#dropdown0000000005 and YearCode = '2022' "

[ayodelebamgboye]

It's not entirely clear what you're asking, and based on your script below, it seems like you want to retrieve the total sales for a specific product in a specific year and month, across multiple customer IDs.

To retrieve the total sales for a specific product across multiple customer IDs, you can use the IN operator to specify a list of customer IDs, like this:
SELECT IFNULL(FORMAT(SUM(Amount),2),0)
FROM tblsalesperformance
WHERE CustomerID IN ('id1', 'id2', 'id3', 'id4', 'id5')
AND YearCode = '2021'
AND MonthCodeint >= @@text0000000097
AND ProductID = @#dropdown0000000005
Replace id1, id2, id3, id4, and id5 with the actual customer IDs that you want to retrieve sales data for.

If you want to retrieve the total sales for a specific product and customer in a specific year, you can use a query like this:
SELECT IFNULL(FORMAT(SUM(Amount),2),0)
FROM tblsalesperformanceproduct
WHERE UserID = @@text0000000085
AND CustomerID = @#dropdown0000000005
AND YearCode = '2022'

[userg19]

Thanks by the way it was solved that day when I posted this. a lot to learn to use this processmaker
. I am working on disapproval but it was complicated when I want to return back to the user when is in the middle of a task/workflow

For example:
1--> 2 -->3-->4
My form is on 4 but I want to return it to 1 then when I submit it again I want to send it back to 4

[SOLVED]
For reference On Grid:
Select IFNULL(format(sum(Amount),2),0) From tblsalesperformanceproduct Where CustomerID in ('@#text0000000098', '@#text0000000099', '@#text0000000100') and UserID = @@text0000000085 and MonthCodeInt <= @@text0000000097 and YearCode = '2023' and ProductName = @@dropdown0000000005