How to calculate a combination of aggregated and non-aggregated field

@abacon @DylanM
Hi,

Myself and @priyadarshini.m facing a difficulty in calculating a calculated field by using both aggregated and non-aggregated field. For example I have a calculated field and I want to use that in another calculated field with other non-aggregated fields but I couldn’t able to do that. Is there any possible way to overcome this issue. Let me know if there is any solution.

Attaching the image for your reference

First one I have created the calculated field and tried to use it in another.
image

Second one is I have made the calculated everything in single calculated field
image

Hello @Haripriya !

Can you try the calculation below and see if it gives you your expected outcome?

periodToDateSumOverTime({CTR},({Date}), YEAR)

Let me know if this helps!

Hey @Haripriya !

I am going to mark my comment as a solution, but please feel free to reach out in the community if you still need help with this!