Hi All, I have an Import Module which has a Number and a Text Line Item. I have created another module with the Dimensions Provided Service and Cost Centre and in the Import Module created List fomatted Line Items for those 2 Dimension. I have successfully pulled across the Number formatted Line item from the Import Module using the SUM: function. This is the formula in the target module 'Import 3 - Consumption Data'.Consumption Volume[SUM: 'Import 3 - Consumption Data'.'Provided Service - Lookup', SUM: 'Import 3 - Consumption Data'.'Cost Centre - Lookup'] I now want to do the exact same thing but returning the Text formatted line item I thought this formula would work 'Import 3 - Consumption Data'.Consumption Unit[LOOKUP:'Import 3 - Consumption Data'.'Provided Service - Lookup', LOOKUP:'Import 3 - Consumption Data'.'Cost Centre - Lookup'] but it appears LOOKUP: can only be used on Amounts and not Text is there an equivalent function for Text? Many thanks Paul
Solved! Go to Solution.
'Import 3 - Consumption Data'.Consumption Unit[FIRSTNONBLANK:'Import 3 - Consumption Data'.'Provided Service - Lookup', FIRSTNONBLANK:'Import 3 - Consumption Data'.'Cost Centre - Lookup']Post back and let me know how you get on. B) Kind regards, Simon
'Import 3 - Consumption Data'.Consumption Unit[FIRSTNONBLANK:'Import 3 - Consumption Data'.'Provided Service - Lookup', FIRSTNONBLANK:'Import 3 - Consumption Data'.'Cost Centre - Lookup']Post back and let me know how you get on. B) Kind regards, Simon
This was a huge help! Thanks Simon