ErrorFlag

[johnan]

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 🙂

[johnan]

ODD i think, 😄

[johnan]

Hmm, or not?

[johnan]

I noticed that if my value is 13 it's ok, but if it's 13,5 it doesent work.

[sunny_talwar]

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?

[johnan]

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

[sunny_talwar · Accepted solution]

Oh you mean if there are no decimals? May be this

If(Mod(Balance, Casepack) = 0, 'Even', 'Uneven')