I am trying to find a change in value from looking at the same field but different revisions.

 

what we do is calculate a claim many times in a month, when we do this it changed a field called "claim revision". everytime we calculate the claim, the latest claim will be value of '0' and the previous claim calculated with go to '1'

 

i can get both revisions to show on the report but what i need is a formula that shows me any changes in money value from claim revision 1 (old) to claim revision 0 (new). i also need it to look at any money value that wasnt on revision 1 but is now showing on revision 0.

 

i was given this formula from our support but it doesnt work.

 

If{CLAIM.Revision} = 0 and
{@Product Total} <> Previous ({@Product Total}) Then True Else
If{CLAIM.Revision} = 0 Then True Else False

 

 

 

RET001      W       50.00     3.00     £150.00

TVL001      W       7.00       3.00     £21.00

 

So we would have this for many people each person will have its own values.

 

what we are trying to achieve, is to show all people which value has chagned from revision 1 to revision 0

 

example