Variance

I have a requirement as follows:

Module SYS 00: From Version (Version list format) , To Version line item (Version list format).

Module 1 : Versions , Cost Center , Line Items . Months

In versions (customized list) , I have Actual , Estimate and Variance.

Line item Cost , Cost Final

In the line item Cost Final, I want to write a logic saying If item(version list) = version list. variance then cost(lookup:sys 00 : from version) - cost(lookup:sys 00 : to version) . This logic is not giving an error but somehow not working. I dont want to create any extra modules. Can shed some light on how I can improvise the logic to achieve the variance between the selected version?

Answers