I want to put a calculated value into my report that is based off the addition of two fields from the most recent effective dated rows in two seperate tables. What would this code look like? Should I create a temp table to hold the variable in order to put it in the report?
Thanks,
Dan
