• 1 reply
  • Latest Post - ‏2009-04-13T17:06:29Z by Paul_Allen
41 Posts

Pinned topic Help with Controller function

‏2009-01-07T21:14:22Z |
Khai Nguyen said:


I'm wondering if there's a Controller 8 function (for Excel reports) which extract values from dimensions indepently from companies?

Using cc.fGetVal(...) you have to specify company and then the proper dimension which then extract the company value registered on that specific dimension. But what if you just want the sum of the dimension indepently of companies (of if you don't know what company is connected to it)?

This can be done with Trial balance... but I also need it in an Excel report.



Khai N.

Updated on 2009-04-13T17:06:29Z at 2009-04-13T17:06:29Z by Paul_Allen
  • Paul_Allen
    13 Posts

    Re: Help with Controller function

    You need to take the top level group (in the company structure) and use that as the company argument in the get value formaula