Hi All,
I got requirement like below,
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.
Regards,Dev
