Calculation to a specific category

[kevin19]

Hi All!
I have a form with the following:
A combo textbox with Category A and Category B.
An Amount texbox.

In the form footer, I have a textbox calculating the sum of the Amount.
This works fine but how do I create a textbox that calculates just the Category A or Category B??

Anyone please?
Thanks!

 

[pr2-eugin]

Are you using DSum on the Form footer to calculate? If so you can add the Criteria to include only Category A or Category B..

 

[Simon_MT]

You could try storing a value in a Table of Categories.

-1 for Negatives
0 for no Sum
1 for Positives

It does not matter if additional Categories are added you just set the rule in the Table.

Simon