Planning Form Formula using If/Then
Most likely a simple request... I'm trying to use an IfThen statement in a formula row on my form. The first row has something like this coding:
Row 1 (data entry):
Project: ILvl0Descendants(Projects)
Account: Salary, Effort
Row 2 (formula row):
Sum of just the salary rows that are created from the first set of rows.
Row 3 (formula row):
Sum of just the Effort rows that are created from the first set of rows.
Desired Output (example):
Project 1 - Salary 25
- Effort 10
Project 2 - Salary 50
- Effort 50
Project 3 - Salary 25
- Effort 25
Salary Total: 100
Effort Total: 85
I'm assuming I start with an IfThen but would need to possible add an Eval or even something related to Cross-Dim.
Thanks-
Cameron