Aggregate functions
Hi,
1. How can i count a field has a specific value? For example a field has F (female) and M (male) value. i want to count F and M different memo like :
Females : 15
Males : 12
2. i want to sum two fields together. My dataset has price and tax values. i want to sum this field like this :
Sum Price ... OK
Sum Tax ..... OK
Sum Price + Sum Tax ... i couldn't do this
Best Regards.
1. How can i count a field has a specific value? For example a field has F (female) and M (male) value. i want to count F and M different memo like :
Females : 15
Males : 12
2. i want to sum two fields together. My dataset has price and tax values. i want to sum this field like this :
Sum Price ... OK
Sum Tax ..... OK
Sum Price + Sum Tax ... i couldn't do this
Best Regards.
Comments
2) SUM(<Table1."Price"> + <Table1."Tax">)
Best Regards.