MDX To Calculate Actual-Budget (Variance)

  • Hi all,

    Could anyone assist me in creating a calculated member to work out variance between actual and budget figures???!!!

    Your help would be appreciated.

  • Hi there

    In the most simplistic terms, if you have a measure of actual and one for budget, you could do a calculated measure simply as ([measures].[budget] - [measures].[actual])

    In Analysis services right click calculated members and add a new one

    If this is not what you are looking for, please give more details of the scenario

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply