5 Replies Latest reply on Oct 17, 2014 7:59 AM by Francisco Amores

    Intragroups or how to load 2 data field into one amount field


      Dear guruz,


      I guess my title has it all... I'd like to load a file with intragroup data which includes 2 data fields on the same row : amounts in transaction currency and amounts in local currency.


      The rule is the following, both data field have to be loaded :

      EUR amount have to be loaded on [NONE] and other amounts have to be loaded on the right currency (OTHER dimension, * to *).


      As far as I could hear this seems complicated with FDMEE when both amounts are on the same row. I was thinking about scripting or any other way.


      Any guidance would be great. Thanks.