AnsweredAssumed Answered

Avg(Material) = result

Question asked by dbanks on Dec 4, 2017
Latest reply on Dec 4, 2017 by dbanks

Hi, I'm trying to create a calculation of a raw material bought on a purchase that gives a result from two of the purchase dates.( a start date and end date)


I am using this sql query in a field to get the result but I'm getting a ?


ExecuteSQL ( " SELECT  AVG(Pounds) FROM Inventory

WHERE Purchase Date BETWEEN ? AND ? "

    ; "" ; "";

Inventory::pdatestart; Inventory::pdateend)


I have created a relationship for pdatestart and pdateend to the Purchase Date also.


Any Ideas where I'm going wrong?