# How can I Calculate that???

This topic is 7156 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

How can I Calculate that??? ( the result is in field "Active & Inactive" )

3 Field

Group Active or Inactive Active & Inactive

10 Active 001 Active 001 Inactive 001

10 Active 001 Active 001 Inactive 001

10 Active 001 Active 001 Inactive 001

10 Inactive 001 Active 001 Inactive 001

10 Inactive 001 Active 001 Inactive 001

10 Inactive 001 Active 001 Inactive 001

11 Active 002 Active 002 Inactive 002

11 Active 002 Active 002 Inactive 002

11 Active 002 Active 002 Inactive 002

11 Inactive 002 Active 002 Inactive 002

11 InActive 002 Active 002 Inactive 002

11 InActive 002 Active 002 Inactive 002

George

##### Share on other sites

I'm not sure what you're asking. Could you be more descriptive?

##### Share on other sites

The group "10" has 1 of 2 values "Active 001" or "Inactive 001"

The group "11" 1 has 1 of 2 values "Active 002" or "Inactive 002"

I want a Calculation to collect the active values and the Inactive values of one group in one field...

Group------Active or Inactive------- Active & Inactive

10------Active 001--------------- Active 001 Inactive 001

10------Active 001--------------- Active 001 Inactive 001

10------Active 001--------------- Active 001 Inactive 001

10-----Inactive 001--------------- Active 001 Inactive 001

10----- Inactive 001--------------- Active 001 Inactive 001

10----- Inactive 001--------------- Active 001 Inactive 001

11----- Active 002--------------- Active 002 Inactive 002

11 ----- Active 002--------------- Active 002 Inactive 002

11 ----- Active 002 ---------------Active 002 Inactive 002

11---- Inactive 002 ---------------Active 002 Inactive 002

11---- InActive 002--------------- Active 002 Inactive 002

11---- InActive 002 ---------------Active 002 Inactive 002

##### Share on other sites

You've lost me.

Is your example showing 12 posible records? If so, the apparent end result is the same in all cases so why do you need a calculatin?

##### Share on other sites

This topic is 7156 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account