Bar Inventory

Discussion created by ivanlow on Oct 25, 2015
Latest reply on Oct 26, 2015 by ivanlow

Hi, I'm new to FMP. So far so good I build all the tables relationship without any problem, but I was not able to get pass 1 calculation. I have many bottles in the bar, some capacity is 750ml and some 700ml. For that I created a field just to store that information. So when come to the sales, we count by 0.030ml per shot. As I accumulate the sales through out the day, I might end up 0.780. I just cannot figure out how to make it calculate when reach 0.700 can count as one while have a decimal value of 0.080 which result 1.080ml. Can you help me? Thanks.