AnsweredAssumed Answered

How to calculat today's Box + last day of saling(Box)? on a chain.

Question asked by HelderSantos_1 on Feb 8, 2013
Latest reply on Feb 8, 2013 by schamblee

Title

How to calculat today's Box + last day of saling(Box)? on a chain.

Post

hello good day
     on my  Sales system, i have Table and fields( date; total_sales; total_expenses; remain; box_day
)

eg:
          date        total_sales   total_expenses     remain_by_day    box_day
     03/01/2013     $50                   $18                        $32                   $99
     02/01/2013     $45                   $12                        $33                  
$67
     01/01/2013     $49                   $15                        $34                   xxx

I intend to calculate the box_day of day 2/1/2013 this way: (34+45) -12  = "67"
     how can make it works?

Outcomes