3 Replies Latest reply: May 15, 2014 10:07 AM by Olly Bond RSS

    Subtraction in Monarch

    Rusch Mauzy

      Is it possible to subtract two numbers within Monarch?

       

      I have Sales volumes for May and June and would like to compare the two numbers within Monarch, without having to export to Excel.

       

      Is this possible?

       

      Thank you,

       

      Rusch

        • Subtraction in Monarch
          Data Kruncher

          Which window are you working in Rusch? The Table or the Summary?

           

          If the Table, then do you have a Month or Period field, so May and June appear in different rows? Or do you have a field for MayValues and another for JuneValues?

           

          If you're working with a summary, is the Month displaying across the top or down?

            • Subtraction in Monarch
              Rusch Mauzy

              Q: If you're working with a summary, is the Month displaying across the top or down?

               

              A: In the Summary window, the month displays across the top.  My question pertained to the Summary window.[/B]

               

               

               

              Q: If the Table, then do you have a Month or Period field, so May and June appear in different rows? Or do you have a field for MayValues and another for JuneValues?

               

               

              A: In the Table window, May and June appear in different rows.

                • Subtraction in Monarch
                  Olly Bond

                  Hello Rusch,

                   

                  Assuming table data like:

                   

                  Betty --- May --- 123.45

                  Betty --- June --- 765.43

                  Fandango --- May --- 987.65

                  Fandango --- June --- 345.67[/CODE]

                   

                  I take it that you're trying to deliver data like:

                   

                  Betty --- June-May --- 641.98

                  Fandango --- June-May --- -641.98[/CODE]

                   

                  In Monarch, you'll need to get the data into the shape:

                   

                  Betty --- (May) 123.45 --- (June) 765.43

                  Fandango --- (May) 987.65 --- (June) 345.67[/CODE]

                   

                  Then you could define a summary with a measure defined as SUM(June)-SUM(May).

                   

                  This is relatively easy in two passes for a small number of months, but it could get complex if you have lots of months or other intervals that require frequent changing. There are multi-column region tricks that might help, but if you have more than 40 intervals then you'll need at least three models - hang on, worse than that, you'll hit limits on summary fields.

                   

                  Before going further, could you give us an idea of the limits of the data?

                   

                  Best wishes,

                   

                  Olly