community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Floor and Ceiling function help

Meteor

Hi again, sorry to be a pain.

 

How would I go about writing a similar formula: 

 

=IF([SS]-[Store Needs Units]<0,0,[SS]-[Store Needs Units])

Meteor

This is what I have, but it isn't working:

 

IF [Store Need Units]-[SafetyStock]<0 THEN 0 ELSE [Store Need Units]-[SafetyStock] ENDIF

Alteryx Certified Partner

Hi @Matt_Sinker, no problem.

 

IF([SS]-[Store Needs Units])<0 then 0 ELSE ([SS]-[Store Needs Units]) ENDIF

Labels