This content has been marked as final. Show 3 replies
I am seeking to create a calculated field using the following data set:
|Jan-12||Lower||Start of Month||220|
|Jan-12||Lower||End of Month||230|
|Jan-12||Main||Start of Month||5524|
|Jan-12||Main||End of Month||5556|
The calculated fields I am trying to get is:
The difference between Jan 12 End of Month (Main) and Jan 12 End of Month (Main).
My expected result should be: 32
Note: my dataset would have several months data so would expect to have to include in the formula the latest month.
Any help would be appreciated.