Hi @Misbah Thanks for the clarification. Yes standard versions does need some improvement. Do see if the following works: 1. Profit & Loss - Simple module with Standard Versions, Standard Time, Countries and simple P&L line items. 2. Profit & Loss (Collect) - A Line Item subset, 'LIS P&L' is created, where it grabs all the line items from 'Profit & Loss' in item 1. This new module uses 'LIS P&L', Countries, Standard Time, Standard Version. It also has 1 line item, Value = COLLECT() 3. Version Selection - A selection module made up Standard Versions, and 2 line items, Version 1 and Version 2. This module will drive the values to be shown in the Variance Analysis report below. 4. Variance Analysis - As you rightly stated, LOOKUP cannot be used on Standard Versions, hence a nested IF THEN ELSE is used. Fortunately we have to do once for Version 1, and once for Version 2. And we can do a SELECT statement on the same COLLECT statement from 'Profit & Loss (Collect)'. The additional benefit of this approach is the different format that we can apply to Variance ($) and Variance (%). 5. Actual vs Version 6. Actual vs Budget. Note: Here's the caveat, because it's a nested IF THEN ELSE, the first selection that meets the criteria will be chosen. So if both Forecast and Budget are chosen in Version 2, then Forecast will still be referred in Version 2. As you can see, there's a lot of SELECT statement and a heavy use of nested IF THEN ELSE, so it's not ideal. And there's a duplicate of data in 'Profit & Loss' and 'Profit & Loss (Collect)'. Do proceed only after discussing the pros and cons with the business users. Thanks, LipChean
... View more
