Is it possible to reference the results of one value in another results field? I'm trying to create a sales report. One results column will be the sum of sales order amounts. The second column will be a hard coded Target amount for that period and the third column will be the first column - the second column. I can get the first 2 no problem, but the third is where i'm having trouble.

I don't think searches work that way. two ways I have approached this. a) replicate the values from column 2 in the col 3 formula. b) put the Col 2 hardcoding on a suitable record so that the customer can update that value and you can then bring that value into Col 2 and use in Col 3.