-
1. Re: Calculate YTD sales Dynamic?
Ritesh Bisht Apr 11, 2018 2:26 AM (in response to pavan kumar)1 of 1 people found this helpfulSTEP 1
Makedate
=MAKEDATE([YTD Parameter],12,31)
STEP 2
if [Order Date]<= [MakeDate] AND
DATEDIFF('year',[Order Date],[MakeDate])=0
THEN [Sales] END
Thanks,
Ritesh
-
2. Re: Calculate YTD sales Dynamic?
chowdary v Apr 11, 2018 2:31 AM (in response to pavan kumar)hi,
here i attached please check
-
YTD Dynamic selection.twbx 1.2 MB
-
-
-
4. Re: Calculate YTD sales Dynamic?
pavan kumar Apr 11, 2018 2:35 AM (in response to chowdary v)Hi Chowdary.
Thanks for the reply.
i am unable to open the workbook
I have 10.2
-
-
-
7. Re: Calculate YTD sales Dynamic?
pavan kumar Apr 11, 2018 2:44 AM (in response to Ritesh Bisht)I did it in that way already.
But the problem is in Parameter values should be 2013, 2014. 2016...
like that.
But if i go by you suggestion Parameter Values will be 26/01/2013 like that.
-
-
9. Re: Calculate YTD sales Dynamic?
pavan kumar Apr 11, 2018 2:52 AM (in response to Ritesh Bisht)I am unable to open the file.
Instead of MAKEDATE is there any alternate way to do it like.
Plz help me . Urgent
-
-
-
12. Re: Calculate YTD sales Dynamic?
pavan kumar Apr 11, 2018 2:57 AM (in response to chowdary v)Hi Chowdary
I did the same thing MAKEDATE Function works only for Extracts.
But here i have LIVE Connection.
Is there other way instead of MAKEDATE like DATEPARSE?
-
13. Re: Calculate YTD sales Dynamic?
chowdary v Apr 11, 2018 2:58 AM (in response to pavan kumar)i think in live makedate is not working
-
14. Re: Calculate YTD sales Dynamic?
chowdary v Apr 11, 2018 2:59 AM (in response to pavan kumar)already i attached one workbook above please check that one