I hope someone can help me with this one. What would be the best way to calculate a value based on specific criteria? I have a Department table and Resources table. I need to calculate number of employees in each department. I am using calculated value in Submission form, but I am not sure how to format the formula.

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.

## Question

## Aleksandra

Hello everyone,

I hope someone can help me with this one. What would be the best way to calculate a value based on specific criteria? I have a Department table and Resources table. I need to calculate number of employees in each department. I am using calculated value in Submission form, but I am not sure how to format the formula.

Many thanks,

Aleksandra

## Link to comment

## Share on other sites

## 9 answers to this question

## Recommended Posts

## 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.