I am trying to write a Quote analysis report, the problem being that the sales people are using Revisions rather than change the original quotation. I have been asked to write the report to show the difference in the Value.
Below is an example of the data, What I need to create is the Highlighted field.
The logic is - if the Suffix is -1 then that is the adjusted value.
If any other suffix it is the last value is the new value minus that last revision.
Hopefully the data below is clear. I have looked at using Peek & Previous but I don't seem to get any meaningful data.
Thanks for your quick reply. I have tried adding the script which seems to do something but the values appear to be picking up different previous values, does the data have to be ordered in the script to pick up the correct previous value??