1 Reply Latest reply: Aug 21, 2013 11:05 AM by Stefan Wühl RSS

    Cell calculation in a table

      Hi folks,

       

      could somebody take a short look at the attached file and tell me if it is possible to calculate each cell like i can do it in Excel?

      My problem is that I can do it only per column and not for each cell. But i.e. for May I need # of logged and # of closed in one column...

      I would be thankful for a short description!

       

       

      Thanks!

        • Re: Cell calculation in a table
          Stefan Wühl

          Dave, I am unsure what your requirements are looking at your attached file.

          Your data model contains no fact data, this might also support my confusion.

           

          Can you post the excel file, too, so we can see what you are trying to achieve?

           

          In general, you can't use a table box for calculations (i.e. using expressions). You'll need to use a chart (pivot, straight table, or one of the graphic charts).

           

          You can then look into the inter chart record functions (above(), below(), before(),top() etc.), these might help you in doing what you want (well, I honestly don't know what you want, see above).

           

          Regards,

          Stefan