Calculated fields: Level Aware Calculations

[ErikG]

Hi @koflote
what kind of “inaccurate figures” do you get?

Maybe you can have a look at:

Previous Year YTD Aggregation functions

Hi ChenjingLyu, I hope below solutions will meet your requirements, kindly check these calculations Max Date: maxOver({your date field}, [ ], PRE_AGG) Between dateDiff(), addDateTime(), truncDate(), and extract() you can define whatever periods you want (and there are often multiple ways to do each one, these are just some proven examples). Please create Parameter ( Name it as AsOfDate ) by selecting fixed date option, then try below calculations Today: ifelse(dateDiff({order_date},${As…

BR