3 Replies Latest reply: Nov 25, 2013 4:45 AM by Mohit Sharma RSS

    Help in Set Analysis Expression

    susvithrocks susvithrocks

      Hi all,

       

      I created a table with some

       

      dimensions and three expressions(Sales,Recurring,%mix).

      The Recurring expression  values will be either 1 or 0.

      My '%mix' expression is

        Sum

       

      ({$<YEAR = {$(=Max(YEAR)-1)}>} SALES)
      /
      Sum(TOTAL {$<YEAR = {$(=Max(YEAR)-1)} >} SALES)

       

      In my '%mix' expression  second part i.e.Sum(TOTAL {$<YEAR = {$(=Max(YEAR)-1)} >} SALES) should act based on recurring value. It should only take 'total ' of those records  whose recurring value is '1'

      PS:Please find attached file for the table and its expressions.

       

      Please let me know how can i change my ' %mix' expression

      Any help would be appreciated.

       

      Thanks in advance.

       

      Best Regards,

      Susvith