Skip to Content

How to show subtotals and grand totals in suppressed row report


We got a requirement to suppress certain rows in CR. What we did is used below mentioned formula for key figure:


If <Condition> then totext (keyfigure) else ""

As we are chaining the key figure, the new {FORMULA1} is not visible under Insert summery list.

  1. Is there a way to derive a new key figure with certain modification, which is visible under Insert Summery list? or
  2. Is it possible to create custom formula to calculate subtotal under each group footer?



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Sep 06, 2013 at 05:09 AM

    Hi Debjit,

    The formula does not look like a Print-Time formula so it should be visible under 'Insert Summary', unless the <condition> part is another formula that is print-time or uses other print-time functions.

    1) Modify the existing Formula1 to :


    numbervar kf;

    If <Condition> then


    keyfigure := keyfigure + kf;

    totext(keyfigure); //Not too sure why you're converting this to string


    else ""

    2) Create another formula with the code below and place it on the Group Footer. This displays the Sub-totals:


    numbervar kf;

    3) One last formula to reset the values. Place this on the Group Header:


    numbervar kf := 0;


    Add a comment
    10|10000 characters needed characters exceeded