3 Replies Latest reply: Feb 23, 2012 10:18 AM by Marc Wintjen RSS

    Using Set Analysis with If Condition based on Dimensional Value

    Marc Wintjen
      Hi,  I'm trying to build an Expression against a 2 dimensional Chart (Year and Category) and I want to use set analysis when the Category = "Budget vs Actual" but a normal expression like "=Sum([Gross Sales])"when the Category is anything else.  The Categories are "Budget, Actual, Variance" and when I try to calculate the Set Analysis of "
      =
      sum({<Category = {'Budget'} >} [Total Discount]) / sum({<Category = {'Budget'} >} Gross Sales])