Variance

BlueSky-Wind chaser · June 2023

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?

Venki9902 · June 2023

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,
Venkatesh

BlueSky-Wind chaser · June 2023

@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

Venki9902 · June 2023

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