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] ) )

Calculated fields: Level Aware Calculations

Q&A

ErikG January 25, 2024, 11:27am 2

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

Maybe you can have a look at:

Topic		Replies	Views
Get last year value (periodOverPeriodLastValue) in a PRE_AGG scope Q&A formulas , feature-request , calculations	5	1264	May 10, 2023
How to compare the last date with other dates in QuickSight Q&A error , quicksight , calculations , Business-Intelligence-Engineer	7	598	December 15, 2023
Calculated field creating Q&A calculations , how-to	3	396	March 2, 2023
Previous Year Total values (at Quarterly Level) in Quicksight Q&A error , calculations	10	1589	April 29, 2024
LAC with If else Q&A filters , date , calculations , Business-Intelligence-Engineer	9	65	July 25, 2024

Calculated fields: Level Aware Calculations

Related topics