I have built a report in excel report builder showing quarterly SOP sales by customer by product, for Q1 for year 2012, 2013, 2014, and Q2 for same years. I need to have 4 calculation columns: Q1 - 2013-2012 & 2014-2013 with columns for the variance %. Same thing for Q2. How do I enter the snytax for these calculations?
thanks.
*This post is locked for comments
My current calc that is not working is: {Sales Transaction Amounts History:Extended Price} where DATEPART ( Q , {Sales Transaction History:Document Date}=1) and where YEAR ({Sales Transaction History:Document Date}=2013)-({Sales Transaction Amounts History:Extended Price} where DATEPART ( Q , {Sales Transaction History:Document Date}=1) and where YEAR ({Sales Transaction History:Document Date}=2012))
the second part of this when it works, is to then calc the % change. that would be this answer / Q1, 2012 amount. thanks!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (