Hi,
I have a summation field that should exclude few record values.
the records are,when product names = 'apples' and 'oranges' then exclude in Gross Sum(totalamount).
So, Net Sum = Gross Sum({totalamount} - sum({total amount}, when Product Name='apples' and 'oranges' )
I am new to crystalXI. Please provide me the solution.
Appreciates.
I have a summation field that should exclude few record values.
the records are,when product names = 'apples' and 'oranges' then exclude in Gross Sum(totalamount).
So, Net Sum = Gross Sum({totalamount} - sum({total amount}, when Product Name='apples' and 'oranges' )
I am new to crystalXI. Please provide me the solution.
Appreciates.