1 Reply Latest reply on Oct 31, 2012 4:50 PM by Anna Chan

    dynamic table calculation depend on date

    Anna Chan

      Hi

       

      I am trying to build an interactive chart where a user there is a constant line (profit) and then a line based on a calcuated field (moving profit). Moving profit would be an equation like this (y=base profit + .5a+1000p+1000p), where a=advertising, p= PR, w=word of mouth. Users can enter the number of units of each advertising, PR, & word of mouth will be included in the model, and the line would update itself. The trick being that users can select the date and then pick volumes of each variable and the formula would only apply after the date of which user chooses. Any help would be GREATLY APPRECIATED.

       

      Anna