Hi,
I need to show only value for "Salted Water" product on "Provided" from table using sum with sql calculated fields.
My formula is:
SELECT SUM(`stockin`.`sti_qtty`)
FROM `site`
LEFT JOIN `stockin` ON `stockin`.`sti_sit_id`=`site`.`sit_id`
WHERE `site`.`sit_id`='%ID%'
But it's all sum for all products.
Where I can insert "Group By" and "Where" value is from my formula?
Regards
sum with group by filter value
sum with group by filter value
- Attachments
-
- Capture d’écran 2021-06-22 à 13.03.19.png (46.35 KiB) Viewed 688 times
-
- Capture d’écran 2021-06-22 à 13.03.57.png (30.46 KiB) Viewed 688 times