How can I Reference a Line Item from a module with time dimension in a module without time dimension

versilva · July 2023

Origin Module: Sales p/Year

Destination module: Present year stock calculation (I am only calculating this for this year, it does not have the time dimension) = Last year sales* Percentage x

I believe this can be simple but I am not managing to complete this task, can you please help me?

AkhilEmmanual · July 2023

HI @versilva you can achieve this by creating a system module with no dimension and creating a line item there called current year. Current year format will be time period and manually select your current year . In target module just refer the source module and lookup by current year line item. you can check the example below for your reference.

Source with time.png

Target without time.png

System module.png

Thanks You

Akhil Emmanual