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.
have a look at exception aggregation
Thanks for your reply Raf,
I tried summation in Exception Aggregation, but it didnt help. Can Any other function help?
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.
This link also helped.
Hi Mariadas,
please check the formula collision setting and choose the one that fits your need.
regards
Cornelia