Hi,
In Crystal report I need to display the sum of a particular column based upon some condition. I'm using SQL database.
I have a Table named A and have in it I have 2 columns say A1, A2.. Can anyone let me know how to get the sum of those entries in A1 whose corresponding A2 is equal to, say, '1' in Crystal Report 10.0.
Thanks
A2 actually holds two values 0 and 1. What i needed was a seperate total depending on its value. Thanks for your help.
But now I've another problem depending on the same. If the total i got is greater than 12 i need to display only 12 and if its less than 12 i need to display the actual value.
Where and how should i give that condition as i have displayed the total using running total??