Skip to Content
avatar image
Former Member

Supress section based on formula from lower sections/groups.

Let's say I have a formula that does a simple subtraction in group footer 3.

My goal is to suppress the sections for groups 1, 2 and 3 everytime {@SimpleFormula} is a negative number. So I used this section supression formula:

if {@SimpleFormula} >= 0 then false

Now this obviously works for group 3 because the formula pertains to it. But it does not seem to work for groups above 3...

What's a good workaround for this situation?

Edited by: Eric Choi on Oct 8, 2008 5:51 PM

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 08, 2008 at 04:20 PM

    you can use it because it is being evaluated at a later time.

    within the formula {@SimpleFormula} >= 0 that indicates what is greater than zero, such as invoice amount etc?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      After testing I'm fairly convinced that the suppression formula is only evaluated based on the first subgroup-level it sees.

      In other words, Group 2's suppression would really depend on whether or not the first instance of Group 3 is a postive or negative. If the first instance of Group 3 is a positive, it will not suppress Group 2. So technically, it does what the suppression tells it to do but there is a problem when there's multiple Group 3's with mixed positive and negative numbers.

      If Group 3 has 3 items showing in the order of negative, postive, negative, Group 2 will look at the first negative of Group 3 and suppress itself. Unfortunately, then that means on the actual report, it will suppress Group 2 but show just the positive instance of Group 3 without a Group 2 instance.

      How can I rewrite this suppression formula so it evaluates all the items under Group 3? Is this even possible?