AnsweredAssumed Answered

Add up a column if...

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

Title

Add up a column if...

Post

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




Outcomes