NetSuite: Saved Search to Show Transaction Amounts YTD vs Rolling Year

 This search shows a comparison of transaction amounts in YTD vs Rolling Year.

YTD

• case when to_char({trandate},'YYYY') = to_char({today},'YYYY') then {amount} end

Rolling Year

• case when {trandate} >=  to_date('01-'||to_char(add_months({today},-12),'MM-YYYY'),'DD-MM-YYYY')  then {amount} end