Calculations Field IF function

Follow

Tom Riddell

• September 19, 2017 04:23

I am trying to create a calculation to show the amount to order.

Fields are @Par Level, @Stock on Hand, @To Order, and @Minimum Order Amount.

Essentially, I want the calculation to show: When stock on hand is equal to or less than the par level, the amount to order is minimum order amount.

I have something along the lines of:

var To_Order; if (@Stock on Hand <= @Par Level) {To_Order = @Minimum Order Amount}

But it doesn't work, and I really do not have any experience with javascript.

0

• 

  Hamid

  • September 20, 2017 08:28

  Hi Tom,

  Try this in a calculation field

  
  var To_Order;
  
  @Stock on Hand <= @Par Level ? To_Order == @Minimum Order Amount : null
  
  To_Order;
  
  

  The calculation show @Minimum Order Amount if @Stock on Hand is less than @Par Level else it show nothing (null)

  You can not populate a text or a number field with podio calculation you should use globiflow for that.

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • September 20, 2017 11:23

  Hi Tom,

  for each IF you need an ELSE. I think this will work:

  @Stock on Hand <= @Par Level ? @Minimum Order Amount : 0;

  If @Stock on Hand > @Par Level it shows 0 (if you want the field blank replace 0 by '')
  
  Rainer

  0

  Comment actions Permalink

Please sign in to leave a comment.