Skip to main content
Announcements
Discover what’s possible with embedded analytics! March 6, 10 AM ET SIGN UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
johnan
Creator III
Creator III

ODD,EVEN and quantity

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.

SKUQuant/CasePackQuantityCasePack ResultNeeds
253-77458010,16666666716True1
253-77458010,16666666716True1
253-7745801166False0
253-77458011,33333333386True2
253-77458012126False0
253-77458012126False0


The Quant/CasePack is calculated in script.

Is this possible?

Br

John

 

 

 

1 Solution

Accepted Solutions
MayilVahanan

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
johnan
Creator III
Creator III
Author

This work perfect, a big thanks