Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to flag if my balance with a casepack is uneven.
Balance = 15
Casepack = 12
Balance/Casepack = Uneven (Just give me 1,if uneven or 0 is even)
Is there a smart funtion to that?
Or someone have it 🙂
Oh you mean if there are no decimals? May be this
If(Mod(Balance, Casepack) = 0, 'Even', 'Uneven')
ODD i think, 😄
Hmm, or not?
I noticed that if my value is 13 it's ok, but if it's 13,5 it doesent work.
When you say even, do you mean = 1? or do you mean even as in 2, 4, 6, 8 and odd as in 1, 3, 5?
Hi, no, i just want to flag if below is ODD
Balance = 15
Casepack = 12
Balance: 15/Casepack (12) = Uneven (1,25) (Give me "Wrong")
Balance: 24/Casepack (12) = Even (2) (Give me "OK")
🙂
BR
Oh you mean if there are no decimals? May be this
If(Mod(Balance, Casepack) = 0, 'Even', 'Uneven')