Last year calculation total sales

[Geral]

Hi, I need to be able to calculate sales from the previous year but it’s marking this error for me, I suppose it’s because of the type of value I have in the current year

[Giridhar.Prabhu]

Hi @Geral

At the looks of it your arithmetic expression of -1 with a date field may not work. You may need to use addDateTime for that.

Please refer to the following artcile that provides you detailed info on computing Period Over Period kind of computations.

Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

Often you may want to create tables and other visuals which display multiple fields that are all ‘filtered’ to different date periods, as well as period-over-period fields. However we can’t use normal filters for this since filters get applied to all fields in the visual. Conceptually in this solution we are building the filters directly into the calculated field itself (using the ifelse logic), so that each field can have a different ‘filtered’ time period. You can then do whatever math you wan…

Regards,
Giri

[ErikG]

HI @Geral
error msg is telling the same. {Year} is a date and {Most recent year} is a number. you cant compare date and number.
Try: ifelse(extract('YYYY', {Year}) = {Most recent year}-1,{Gross Sjipped GMS},0)
BR

[Brett]

Hi @Geral,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

[Brett]

Hi @Geral,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!