Joined: 18 May 2010
Online Status: Offline
Posts: 70
Topic: Date Parameter minus 1 year to get data Posted: 10 May 2012 at 7:26am
I am using this formula below and it is not grabbing prior year MTD data. what am I doing wrong? I use the same basic formula to get this year MTD and it works.
if month({?Date})=month({SO_SalesOrderHistoryHeader.OrderDate}) and year({?Date})-1 = (year({SO_SalesOrderHistoryHeader.OrderDate})) then {SO_SalesOrderHistoryHeader.TaxableAmt}+{SO_SalesOrderHistoryHeader.NonTaxableAmt} else 0
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum