AnsweredAssumed Answered

Conditional Calculation

Question asked by LorrieWhite on Jan 26, 2015
Latest reply on Jan 26, 2015 by philmodjunk


Conditional Calculation


Can you help me with a simple way to perform a conditional calculation?  I have 2 tables - Item Master which holds static information about an item - and Item Detail which holds purchase detail information of that item.  In each table I have a calculated field for cost per serving.  Currently in the Item master, my calculation is Max (Item Detail::Serving Cost).  My problem is I only want to consider the detail records that I actually still have in inventory (Item Detail::Qty OH > 0).  Is there a way to add a conditional statement to the Item Master Calculation?