Skip to main content
Answer

Help with variable expression

  • February 4, 2025
  • 3 replies
  • 59 views
S
Jr Varsity II
Forum|alt.badge.img

Hi all,

I’m calculating labor cost for a generic inquiry using this:

=Round( CInt( [AMProdTotal.ActualLaborTime] ) /60.00 , 2 ) * 47.33

But, I would like change that default rate if the following user names are true:

=iif(InStr([CreatedByUser.Username], 'barcode')>0 or InStr([CreatedByUser.Username], 'slitter')>0, Cint([AMMTran.LaborTime]), 0)

Is there a way to say, labor rate is 94.66 if username contains “X” or “Y”, otherwise labor rate is 47.33?

 

Also, I’m trying to calculate the labor time here based on username, converting the minutes into hours, but I have this messed up! (probably the parentheses!) Any ideas?

Thanks for any input!

Best answer by lauraj46

Hi ​@swartzfeger ,

Try this:

=Round( CInt( [AMProdTotal.ActualLaborTime] ) /60.00 , 2 ) * iif((InStr([CreatedByUser.Username], 'barcode')>0 or InStr([CreatedByUser.Username], 'slitter')>0) and CDbl([InventoryItem.UsrCNbrofColors])>0, 94.66, 47.33)

I don't think the expression builder is C#.  If you click the pencil icon, it opens a formula builder and you can expand the tree to see the available functions and operators.

Hope this helps!

Laura 

3 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • lauraj46
  • Captain II
  • February 4, 2025

Hi ​@swartzfeger ,

You can combine the two formulae like this:

=Round( CInt( [AMProdTotal.ActualLaborTime] ) /60.00 , 2 ) * iif(InStr([CreatedByUser.Username], 'barcode')>0 or InStr([CreatedByUser.Username], 'slitter')>0, 94.66, 47.33)

Hope this helps!

Laura

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Chris Hackett
S
Jr Varsity II
Forum|alt.badge.img
  • swartzfeger
  • Author
  • Jr Varsity II
  • February 4, 2025

Hi ​@swartzfeger ,

You can combine the two formulae like this:

=Round( CInt( [AMProdTotal.ActualLaborTime] ) /60.00 , 2 ) * iif(InStr([CreatedByUser.Username], 'barcode')>0 or InStr([CreatedByUser.Username], 'slitter')>0, 94.66, 47.33)

Hope this helps!

Laura

Laura thank you SOO much… that works but I forgot one part of the variable:

if username is ‘x’ or ‘y’ AND [InventoryItem.UsrCNbrofColors] is GREATER  THAN 1

Sorry for the bother, I need to search for a guide on how to write variable expressions (I think it’s just garden variety C#?)

lauraj46
Captain II
Forum|alt.badge.img+8
  • lauraj46
  • Captain II
  • Answer
  • February 4, 2025

Hi ​@swartzfeger ,

Try this:

=Round( CInt( [AMProdTotal.ActualLaborTime] ) /60.00 , 2 ) * iif((InStr([CreatedByUser.Username], 'barcode')>0 or InStr([CreatedByUser.Username], 'slitter')>0) and CDbl([InventoryItem.UsrCNbrofColors])>0, 94.66, 47.33)

I don't think the expression builder is C#.  If you click the pencil icon, it opens a formula builder and you can expand the tree to see the available functions and operators.

Hope this helps!

Laura 

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Chris Hackett
S
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved