Retrieving a date to a module without time dimension

HugoVolpi
HugoVolpi
edited August 9 in Modeling

Hi All,

I have a question regarding the last date of an item, to a module without dimension.

Let me explain, i have this module :

image.png

with thoses dimensions :

image.png

My purpose is to get the result of the input in a module only dimensionned by "s Active" (subset of my employee list) and regarless the version, to get something like this something like this

image.png

I tried with the Select Time.All Period but the model does not have total or summary.

Any leads i could try ?

Best Answer

Answers

  • Sai_Bharadwaj_Venati
    Sai_Bharadwaj_Venati

    I don't think you can pull data directly without top level into another module with straight forward formula.

    Couple of alternate approaches: -

    Option 1: Create a fake version list with top level and map it to native versions for pulling data and you can use last non blank for getting date summary

    Option 2: If fake version list doesn't have top level, you can create a new dummy list and keep it in target module dimensions. In source module create a line item formatted by dummy member and aggregate the source numbers into target module by using sum.

    Note in Option 2 you wouldn't be able to sum by date, you should create a number equivalent to date and get the values. once you get the value with summary you should get back the date

    V.Sai Bharadwaj

    Connect on LinkedIn

  • HugoVolpi
    HugoVolpi

    @Tiffany.Rice it worked ! thank you, i have forgotten it could be also handling dates, thank you.

    @Sai_Bharadwaj_Venati indeed, if not for the timesum function, your case was working too.

    Thank you all,

    Regards,

  • Sai_Bharadwaj_Venati
    Sai_Bharadwaj_Venati
    edited August 10

    @HugoVolpi can you share the formula once? You are using native versions which dont have summary and in your target as well you dont have native version

    V.Sai Bharadwaj

    Connect on LinkedIn

  • HugoVolpi
    HugoVolpi

    I hide the 3 names before the two lines items "Date de Sortie" and "Date de Sortie Final"

    image.png
    image.png
    image.png

  • HugoVolpi
    HugoVolpi
    edited August 13

    @Callahan09 was it directed to me ?

    If yes, what about reading two messages above where i am thanking them and sharing my formula ? I hope i am wrong on my assumptions because if it was , you didn’t read anything about the conversation and just accused me with a bad comment and being condescending for nothing

Categories