Skip to Content

How to show subtotals and grand totals in suppressed row report

Hi,

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

{FORMULA1}

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?

Thanks,

Debjit

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 :

    whileprintingrecords;

    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:

    whileprintingrecords;

    numbervar kf;

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

    whileprintingrecords;

    numbervar kf := 0;

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded