Jump to content
Sign in to follow this  
George TOUBALIS

How can I Calculate that???

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

AnyBody? Please!

George

Calculation.jpg

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
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 this post


Link to post
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 this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    comment 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.