Select Function using Versions

prabhu
prabhu
in Modeling

Hi,

In version settings, I have 2 versions

                                          1. Actual 2. Forecast

                       but none of those versions are marked as True for Current (Refer screen-shot).

 

I Created 2 Modules 1. Source Module 2. Target Module

Source Module has Versions and Locations as a dimensions, Line Item - Source LI (Number)

Target Module has Locations as a Dimensions, Line Item - Target LI(Number).

 

When I write a formula(Source LI[SELECT: VERSIONS.Actual]) to get the actual value, It throws an error.

After that When I Mark True as Current for Actual Version my formula works.

 

May I know why my formula works if it is marked as true.

A screenshot is attached.

Tagged:

Best Answers

  • kavinkumar
    kavinkumar
    Answer ✓

    @prabhu,

    Please check the syntax once again. {Module.Lineitem[Select:Versions.Actual]}.

    If the current version is checked, then that version's data will be flown to the target module. Ex. In your case, Source has version dimension but target doesn't have. So ultimately if you write a formula (Source.Line item) then the actual version's data will be populated in the target module. You can avoid using Select function.

    I hope this helps.

    Regards,

    Kavin.

  • VIGNESH.M
    VIGNESH.M
    Answer ✓

    Hi Prabhu,

     

    I tried your scenario, it's working fine. Please see the screenshot. I didn't mark any version as current.

    001.png

     

    Regards,

    Vignesh M

  • Misbah
    Misbah
    Answer ✓

    @prabhu 

     

    Can you please check formula once again. If you are not referencing the line item by clicking on source line item and if there are any special characters in your line item you will get an error.(lot of assumptions I am making :))

     

    Formula what you are writing is correct.

    It should be - Source Line item[SELECT: VERSIONS.Actual]

     

    Misbah_0-1576133111039.png

    Misbah_1-1576133136348.png

    Hope this helps

    Thanks,

    Misbah

     

Answers

  • prabhu
    prabhu

    Thanks, Kavin

     

    If Current is marked as true for Actual Version, then writing a formula in Target Module (SourceModule.SourceLI)

    will populate the actual version's data. But, my purpose in writing the formula is to calculate the variance between actual and forecast. 

    In this case, can't I able to use select particular versions to populate in my target module( if Current is marked as false in version )

     

    Thanks,

    Sorna Raja Prabhu

  • prabhu
    prabhu
    Thanks Misbah.
  • prabhu
    prabhu
    Thank's Vignesh. It Works
  • kberger1
    kberger1

    Thank you! This has made my day. I can know use my "proposed" version and display budget and actual while allowing inputs for the proposed new amounts.

Categories