Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a small dataset that brings in some financials, a year field and a text field called Season. I'm looking to have 2 sets of data, one for the max financial year selected and one for last. The figures aren't an issue, they're working fine but it's the titles I'm struggling with. For the max year =If(Max(Year)=Year,Season) works, but what do I need to do for the previous year?
Thanks
Where exactly are you showing this information? May be try this:
Only({<Year = {"$(=Max(Year) - 1)"}>}Season)
or
Concat({<Year = {"$(=Max(Year) - 1)"}>}Season, ', ')
May be this?
=If((Max(Year) - 1) = Year, Season)
No, comes up blank
Where exactly are you showing this information? May be try this:
Only({<Year = {"$(=Max(Year) - 1)"}>}Season)
or
Concat({<Year = {"$(=Max(Year) - 1)"}>}Season, ', ')
Hey there,
Can you share a qvw sample so that we can see where you're using this expression.
Might be helpful see this post:
Re: Current Years Current Month Vs Last Year Same Month Sales
Regards,
MB
Worked a treat, thanks