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?

Outcomes