none
Variance Calculation RRS feed

  • Question

  • I am trying to calculate variance with the below data structure.  I am quite new to BI so any help or input would be much appreciated.  James

    Company   Code Country Plant Scenario Period  r+w Returns  Fiscal Year
    US10 US US18 Actuals 1                38,218 FY17
    US10 US US18 Actuals 2                33,780 FY17
    US10 US US18 Actuals 3                25,500 FY17
    US10 US US18 Actuals 1                (1,710) FY17
    US10 US US18 Actuals 1 FY17
    US10 US US18 Actuals 2 FY17
    US10 US US18 Actuals 3 FY17
    US10 US US18 Actuals 1                24,510 FY16
    US10 US US18 Actuals 2                28,470 FY16
    US10 US US18 Actuals 3                19,260 FY16
    US10 US US18 Actuals 1 FY16
    US10 US US18 Actuals 2 FY16
    US10 US US18 Actuals 3 FY16
    US10 US US18 Forecast 1                38,218 FY17
    US10 US US18 Forecast 2                33,780 FY17
    US10 US US18 Forecast 3                25,500 FY17
    US10 US US18 Forecast 1                (1,710) FY17
    US10 US US18 Forecast 1 FY17
    US10 US US18 Forecast 2 FY17
    US10 US US18 Forecast 3 FY17
    US10 US US18 Actuals 1                39,365 FY18
    US10 US US18 Actuals 2                34,793 FY18
    US10 US US18 Actuals 3                26,265 FY18
    US10 US US18 Actuals 1                (1,761) FY18
    US10 US US18 Actuals 1                           -   FY18
    US10 US US18 Actuals 2                           -   FY18
    US10 US US18 Actuals 3                           -   FY18
    US10 US US18 Forecast 1                40,129 FY18
    US10 US US18 Forecast 2                35,469 FY18
    US10 US US18 Forecast 3                26,775 FY18
    US10 US US18 Forecast 1                (1,796) FY18
    US10 US US18 Forecast 1                           -   FY18
    US10 US US18 Forecast 2                           -   FY18
    US10 US US18 Forecast 3                           -   FY18

    Monday, August 7, 2017 2:00 PM

All replies

  • James,

    I don't see anything in your post that relates to Microsoft Project, however this forum is exclusively for questions about that application. I'm not sure where to direct you since you don't state what application, Microsoft or other, you are attempting to use. You might consider expanding your question including information on what you are trying to do and what software application you are using and then start with the following forum:

    https://social.technet.microsoft.com/Forums/en-US/home?forum=whatforum

    John

    Monday, August 7, 2017 2:36 PM