How to create a calculated field for 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?
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]

Hi @bettersinner. You may be able to accomplish this using the periodToDateSum function.

1 Like