Hi, I need help with a formula. I need to identify any cells that do NOT have a whole number. Any suggestions?
Hi @reginawhelan
Output the calculation to a Column and then check Whole or Not Whole. And numeric function is allowed on NULL it doesnt create error. You can use the below formula to flag NULL
if isempty([Field1]) then 'Null' Elseif ([Field1]-Round([Field1], 1))=0 then 'Whole' Else 'Not Whole' Endif
Check and let me know.
Did it solve @reginawhelan ?
Hi @reginawhelan ,
Here is how you can do it. Use this formula.
if ([Field1]-Round([Field1], 1))=0 then 'Whole' Else 'Not Whole' Endif
Output:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀
Hi 🙂 Thank you but I'm not seeing the desired results with this formula. I will explain a little...
Formula #1 divides two numbers from two columns, I changed the Data Type to 'FixedDecimal - 19.2'.
Formula #2 is your suggestion but I added an IsNot Empty as I don't want an error produced if the cell is NULL.
IF !IsEmpty(([Field]-Round([Field], 1))=0) THEN 'Whole' ELSE 'Not Whole' ENDIF
One of the numbers from formula #1 is 0.7 and should be identified as NOT WHOLE but the above formula indicates that it's WHOLE.
Do you know what the problem could be?
Have I missed something or could we not use a regex_match function here?
IF REGEX_Match(ToString([Numbers]), '\d+') THEN 'Whole' ELSE 'Not Whole' ENDIF
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.
Regards,
Jonathan
