Hi guys, I am trying to calculate last year for my metric in Quicksight calculated field but i keep having inaccurate figures. What i am trying to achieve is: max(numerator) grouped by months and Vendor for last year 2)sum(denominator) for last year numerator/denominator I have done this calcula…

@koflote Try this for your second calculated field: sum( max( ifelse( {end_of_month}>={Last Year} AND {end_of_month}<={Current Year}, Denominator, null ), [{Vendor Code}, Year, Month] ) )