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

# Subtraction in Monarch

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

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

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

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