Let's say online Customer ordered 14 piece of ladies bag to xx shoes company and that xx company have two size of box cartoon like,
1) Box cartoon : 4 piece (maximum capacity) --> assume as A value
2) Box Cartoon box : 6 piece (maximum capacity --> assume as B value
and we assume Customer ordered Piece 14 as C
How to find X & Y value?
XA+YB=C
1) Example,
4X+6Y=14 (if we consider X is 2 and Y is 1 then it should tie with C, how to solve above equation ? need to find x & y automatically
2) Example
what if i give you A=922 and B=532 and C=1000000
need to be able to find if x and y even exists without using method if exhaustion of meaning trial and error?
Note: Given X and Y is whole number and positive values
What i've tried is below,
i figured out till c-xa has to be divisible by b. which leads to sum of c mod b and -xa mod c has to be divisible by b then i'm stucked on how to fine the set of x other than exhaustion.
is there anyway to prove above expression using qlikview? or other logic. kindly provide your valuable suggestions. Many Thanks and happy weekend.
