AnsweredAssumed Answered

Add up a column if...

Question asked by steelbut on Mar 9, 2009
Latest reply on Mar 9, 2009 by steelbut


Add up a column if...


I am working to add a column if another column has these values and I have tried all types of combinations adn hopefully someone a lot smarter then I can help with making this work.


One of the combinations I have been tring is ;


Case (
Jobs::final_delivery_communication  =
"Final"; mfg over_under;
Jobs::final_delivery_communication   =
 "Wait Fac" ; mfg over_under;
Jobs::final_delivery_communication   = 
"Wait Cus" ; mfg over_under;
Jobs::final_delivery_communication =  
 "Week of"; mfg over_under)


Basiclly I am looking to see if the field  Jobs::final_delivery_communication have those values and if they do add the numbers together in mfg over_under. 


The weird thing is if you click around in the fields the date changes and value changes in the field I am tring to calclate above...  On the date I am calling Get(CurrentDate) from the auto-enter.  


Thanks, Larry