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
-
Hi @aishabhy05 ,
I believe that this is what you are trying to achieve right?.
You can achieve this by using the select formula without even the need of sys00 module.
Hope this helps :).
Regards,
Venkatesh0 -
@Venki9902 i m not able to use the select statement from sys00 version module. I want the select statement to be dynamic because the variance will not always be between actual and estimate. I want to give flexibility to user to select the versions to compare
0 -
Hi @aishabhy05,
Got your question.
Create one extra line item in the sys01 module apply whatever there in applies to except version dimension.
Then in the cost final line item apply if item(my version)= my version.variance then test else 0
Hope this helps :).
Regards,
Venkatesh1 -
@aishabhy05 I might be misreading the dimensionality but still giving it a try:
2 -
Check out this document, it might help.
1