Aggregate functions

carpe_diem · December 2004

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.

AlexTZ · December 2004

1) use SUM: SUM(IIF(<Table1."Field1"> = 'F', 1, 0))
2) SUM(<Table1."Price"> + <Table1."Tax">)

carpe_diem · December 2004

thanks,

Best Regards.

Aggregate functions

Comments

Leave a Comment