Visokio website     Downloads     Video tutorials     KnowledgeBase  
Formulae: Using Variables in What-If Analysis - Visokio Forums
Formulae: Using Variables in What-If Analysis
  •     paola June 19, 2013 1:39PM
    Attached file is demonstrating use of variables in What if analysis (in shape of sliders); to see how will different resource allocation scenarios affect Total Cost (time allocated between 3 products), also how will the individual product Sale figures affect totals and net profit.
    To make sure total resource allocation is limited to 100%, Dial view is in place to monitor and issue warnings.
    image
  • 1 Comment
  •     paola June 19, 2013 1:55PM
    One of the formulas used in this file combines static field values, such as [Cost], with flexible variable values e.g. [A % time]

    (SUBSET_SUM([Cost], SUBSET([Product],"A","=")) *[A % time]
    +
    SUBSET_SUM([Cost], SUBSET([Product],"B","=")) *[B % time]
    +
    SUBSET_SUM([Cost], SUBSET([Product],"C","=")) *[C % time])
    /
    100

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Tagged