Results 1 to 2 of 2

Thread: Formula

  1. #1
    Join Date
    Jan 2008

    Unanswered: Formula


    I have a cross tab report with Region and Customer on the left and Product on the top and below
    product have current and previous year values with a growth percentage.

    The growth percentage per Customer works fine, but not sure how to adjust it to calculate
    the Region Sub Total growth correctly.
    Below the formula I used to calculate growth on the Customer level:

    if Sum ({@PreviousYear}, {Command.Customer})=0 then 0 else
    (Sum ({@CurrentYear}, {Command.Customer})-Sum ({@PreviousYear}, {Command.Customer}))/Sum ({@PreviousYear}, {Command.Customer})*100

    Any help wil be appreciated.


  2. #2
    Join Date
    May 2010
    Group your data as Region.
    {Command.Customer} in the formula replace with the region group name.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts