AnsweredAssumed Answered

show total of quantity between two date 

Question asked by mahasubhi on Jul 19, 2018
Latest reply on Jul 30, 2018 by mahasubhi

??..... i have write this code in calculation field but it not work

I want to show total of quantity between two date

 

 

")ExecuteSQL

 

(SELECT SUM (Quantity_Received_Sum_of Delivery Receipts

FROM products_PURCHASE ORDER LINE ITEM

JOIN PRODUCTS as products_bom line item_PURCHASE ORDER LINE ITEM::_fk Product ID ON products_bom line item_PURCHASE ORDER LINE ITEM  = __pk Product ID

WHERE

Posting Purchasing Order Date >=  ? and

Posting Purchasing Order Date <= ?

;"

; ""

; ""

StartDating_Dashboard ; EndDating_Dashboard

(

Outcomes