I need to extract the Quarter To Date (QTD) Sell through Dollars. I have written one command and it worked: It can successful drag data for QTD 2018.
ZN(IF [Time-Curr Fis QTR]="Yes"
[Sell Thru Dollars]
But when I want to do QTD for a more detailed level: 2017 Q1,
ZN(IF [Time-Curr & Prev Year (QTR)] = 'Yes' AND [Time-Prev Fis Year] = 'Yes' AND str(DATEPART('year',[Fiscal Year] ))= '2017' AND str(DATEPART('quarter',[Fiscal Quarter] )) ='1'
THEN [Sell Thru Dollars]
Is it because the way I index the data is not correct?
I cannot give out data, i am sorry. I just want some advice for the code.
Thanks and best regards,
We don't need actual data, but it's VERY helpful if you could attach mocked up data as twbx.