Skip to Content
0
Sep 01, 2023 at 09:08 AM

Aggregation on Date with null measure values

76 Views

Hello everyone,

I wanted to perform an aggregation calculation (an average) in a table based on the values of EPT (= FTE) for a given year and version. I have made the following configurations,

image.png

but when there are zero values (due to employment starting in the middle of the year or ending before the year's end), the numbers are not aggregated for the entire year but only for the non-zero months.

image.png

Is there anyone who could assist me in solving this issue without having to replace the zero values with actual zeros, please?

Have a good day

Attachments

image.png (26.8 kB)
image.png (17.9 kB)