I was hoping someone could help me please.
I am trying to pull out counterparty information from Controller 8 in relation to intercompany sales.
I can pull out each sale to each counterparty seperatly but ideally I would like to use the formula to pull the total amount split by x number of counterparties.
This is the formula I am using to pull out ths individual counterpartys:
=cc.fGetVal(*period*,,"ytd","AC",selling co,,,"LC",interco sales account code,,,,,,,,,,,*counter party*)
but I was hoping for something a bit more dynamic!
Thanks very much