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,
Kellie
1 Like
Amazing! You are right - the null issue fixed after I changed the aggregation