![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
Hi, I've got a Margin measure which is calculated from (Sales-COGS) and a "Total Expenses" which sums 3 measures, and I've got a Scenario dimension with Actual, Budget and 2 variances (% and numeric). I'm having problems to ask MS AS to first calculate the Measures and then the Scenario. For some of my Measure the result is correct, for others It returns "infinite". Any idea ? Thanks Bob |
#3
| |||
| |||
|
|
Bob, check out Solve Order -- a calculated member property. tom @ the domain below www.tomchester.net "Bob" <Bob (AT) nowhere (DOT) com> wrote in message news:up9zyj6oDHA.1096 (AT) TK2MSFTNGP11 (DOT) phx.gbl... Hi, I've got a Margin measure which is calculated from (Sales-COGS) and a "Total Expenses" which sums 3 measures, and I've got a Scenario dimension with Actual, Budget and 2 variances (% and numeric). I'm having problems to ask MS AS to first calculate the Measures and then the Scenario. For some of my Measure the result is correct, for others It returns "infinite". Any idea ? Thanks Bob |
![]() |
| Thread Tools | |
| Display Modes | |
| |