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?