Former Member

### Sumct function for formula issue

Hi All,

I am facing an issue with sumct. Sumct is not getting applied on formula.

I have 2 column a and b.

Third column C is a formula with condition (if b>a, than b – a, else 0).

If there are two row. In first row a = 50 and b = 100, c will show as 50.

In second row a=100 and b= 20, c will show 0 as (b<a).

Now if I am applying sumct on C, it is displaying 0.

Sumct is getting applied on subtotal of a and b. i.e. a= 150 and b=120, hence it is showing 0.

But I want it to show 50, as I have to do further calculation on it.

How can this be achieved.

Kindly Help.

10|10000 characters needed characters exceeded

Jan 12, 2017 at 08:21 AM

have a look at exception aggregation

10|10000 characters needed characters exceeded
• Former Member
Jan 12, 2017 at 11:30 AM

I tried summation in Exception Aggregation, but it didnt help. Can Any other function help?

10|10000 characters needed characters exceeded
• Former Member
Jan 12, 2017 at 01:16 PM

Thanks Raf,

I tried summation of Exception Aggregation on sumct (a).

And than created another Formula with standard aggregation on Sumct (sumct(a)).

This solved the issue.