Variance

aishabhy05 · 2023-06-26T09:06:25+00:00

There was an error rendering this rich post.

aishabhy05

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?

Accepted answers

All comments

Venki9902

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

aishabhy05

@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

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

ankit_cheeni

@aishabhy05 I might be misreading the dimensionality but still giving it a try:

rob_marshall

@aishabhy05

Check out this document, it might help.

https://community.anaplan.com/discussion/98336/variance-analysis-with-native-versions-made-easy

Quick Links

Can you help?

Unanswered questions

Dimensionality - Formula Help
I have a Price module where customers are ranked based on their unit prices. I also have a Comparison module, where I want to display the names and unit prices of top-ranked customers for comparison. The model includes a Customers list. In the Comparison module, I want to write formulas to bring in the customer names and…
Can there be a duplication in Process ID's
Can there be a duplication in Process ID's
Using Polaris and Classic
Client has spoke models built in Classic and now considering building Data Hub in Polaris in order to deal with sparsity. On the surface this seem possible but likely a bad idea. Has anyone done anything similar to this? Specifically, what did you have to do to ensure that data was compatible? Any thoughts or suggestions…