is that possible?
Here's why... the two values don't always 'add down' so to speak, let's say I have 60000 for my beginning balance and 70000 for my ending balance. When you go down through all the other adds and subtractions, there are too many to get into all of them here, the ending balance number doesn't always come up the same as what it does if you calculate all the adds and subtractions in between. This is fine, however I would just like to show the difference in it's own row
here's what i want to see
beg balance 60000
adds 10000
ending balance 69000 (should read 70000, but because of the way things happen, it doesn't and it's fine I just want to show the difference)
variance 1000
Problem is I don't know how to use a measure from a different time frame. Can it be stored somehow to use next month?
Here's why... the two values don't always 'add down' so to speak, let's say I have 60000 for my beginning balance and 70000 for my ending balance. When you go down through all the other adds and subtractions, there are too many to get into all of them here, the ending balance number doesn't always come up the same as what it does if you calculate all the adds and subtractions in between. This is fine, however I would just like to show the difference in it's own row
here's what i want to see
beg balance 60000
adds 10000
ending balance 69000 (should read 70000, but because of the way things happen, it doesn't and it's fine I just want to show the difference)
variance 1000
Problem is I don't know how to use a measure from a different time frame. Can it be stored somehow to use next month?