Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have invoice date '20200831' format in purchase order data so now i want to compare thise year purchase amount vs last year purchase amount by months using bar chart
Hi @Vinni2000 ,
First get the year in the script using:
Year(Date#(FieldName, 'YYYYMMDD')) as Year
Sum({<Year = {"$(=Max(Year))"}>}purchase_amount)
Previous Year:
Sum({<Year = {"$(=Max(Year)-1)"}>}purchase_amount)