Forum Discussion

MarcUrdang's avatar
MarcUrdang
Icon for Post Patron rankPost Patron
6 years ago
Solved

variance calculation

Please advise on how to create a variance and a variance % as per below: I have created two calculations which compute a measure for a period of time. This year to date and last year to date:   1....
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    MarcUrdang 

    Give this a try.

    Variance = DIVIDE ( [This YTD], [Last YTD] ) -1
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
6 years ago

MarcUrdang 

Give this a try.

Variance = DIVIDE ( [This YTD], [Last YTD] ) -1