How do I create a calculated field to get a YTD CPH?
Column 1 |
Column 2 |
Column 3 |
Column 4 |
E |
F |
G |
ACCOUNT |
Jan |
Mar |
April |
May |
June |
YTD |
Lodging |
xx |
xx |
xx |
xx |
xx |
xx |
Airfare |
xx |
xx |
xx |
xx |
xx |
xx |
Total |
|
|
|
|
|
|
Headcount |
xx |
xx |
xx |
xx |
xx |
xx |
|
|
|
|
|
|
|
CPH |
total Jan / HC |
total Feb / HC |
total Mar/ HC |
total Apr/ HC |
total Jun / HC |
YTD total/average HC(jan to June) |
|
|
|
|
|
|
|
|
How to create a calc field to get year to date YTD CPH? |
|
|
|
|
|
How do I create a calculated field to get a YTD CPH? |
|
|
|
|
|
|
Column 1 |
Column 2 |
Column 3 |
Column 4 |
E |
F |
G |
ACCOUNT |
Jan |
Mar |
April |
May |
June |
YTD |
Lodging |
xx |
xx |
xx |
xx |
xx |
xx |
Airfare |
xx |
xx |
xx |
xx |
xx |
xx |
Total |
|
|
|
|
|
|
Headcount |
xx |
xx |
xx |
xx |
xx |
xx |
|
|
|
|
|
|
|
CPH |
total Jan / HC |
total Feb / HC |
total Mar/ HC |
total Apr/ HC |
total Jun / HC |
YTD total/average HC(jan to June) |
|
|
|
|
|
|
|
|
How to create a calc field to get year to date YTD CPH? |
|
|
|
|
|
[/quote] |
|
|
|
|
|
|
Max
2
Hi @bettersinner. You may be able to accomplish this using the periodToDateSum function.
1 Like