i would like to get inventory DOI calculation from module-KPI DOI to module-Inventory ending report. Therefore, i inserted 1 line item call DOI into module-Inventory ending report then put formula as below.
Then i get below error message.
You can refer to attached document for 2 modules blueprint.
in module inventory ending report(3 dimension) and KPI DOI(2 dimension) you have different dimension, if you want get data form different dimension you need to mapping, example (division HFM to division L3).
first of all, are you sure you need FX as a dimension and not an attribute?
Does one division have multiple currencies?
Now to your main issue .... when you have a Source and a Target module where you want to reference or retrieve a value, you can only use target module line item = Source mosule.Line Item - like the formula you provided - only if all the dimensions of both modules match.
When you have a difference in dimensions -like the current case- you have to use the LOOKUP function.