Calculations Field IF function
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.

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.
Please sign in to leave a comment.
Comments
2 comments