MoM percent difference

Hi team, I have a questions about calculating the MoM percent difference, my calculation is
periodOverPeriodPercentDifference(sum({securitylake_rev}),{calendar_date}) , however the result shows blank, any ideas? Thanks in advance!

Hi @Rachel1-
I think your calendar_date aggregation in the date column in your field well may be day based upon the format of the calendar date showing. Change that aggregation to month and I think you calculation will give you the expected results.

Best Regards,

1 Like

Amazing! You are right - the null issue fixed after I changed the aggregation