ODD,EVEN and quantity

[johnan]

Hi, i want to identify products that is not even to a casepack.
Mydata:

Column Result and Needs is the data i want. Even better if a can choose True/False in a dimension.

SKU	Quant/CasePack	Quantity	CasePack	Result	Needs
253-7745801	0,166666667	1	6	True	1
253-7745801	0,166666667	1	6	True	1
253-7745801	1	6	6	False	0
253-7745801	1,333333333	8	6	True	2
253-7745801	2	12	6	False	0
253-7745801	2	12	6	False	0

The Quant/CasePack is calculated in script.

Is this possible?

Br

John

[MayilVahanan · Accepted solution]

Hi @johnan 

Try with Mod function

Load *,

Mod(Quantity, CasePack) as Needs,

If(Mod(Quantity, CasePack) = 0, 'False', 'True') as Result

From ursource;

Hope it helps

[johnan]

This work perfect, a big thanks MayilVahanan