Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Any idea why the following occurs?
Expression1 (works):
Sum({$<[Time.Month ID] ={$(=Date(Max([Order.Receive Date]), 'YYYYMM'))}>} [Order.Request Value]) --returns 201008
Expression 2 (doesn't work: trying to figure out sntax to return 201007):
Sum({$<[Time.Month ID] ={$(=Date(Max([Order.Receive Date]), 'YYYYMM')-1)}>} [Order.Request Value]) -returns 40394
Any help would be appreciated!
Thanks,
Dan
Hi,
I tried in another way to get the required o/p
=
Date(AddMonths((TODAY()),0),'YYYYMM') IT returns 201008
=
Date(AddMonths((TODAY()),-1),'YYYYMM') It RETURNS 201007
I think u need to implement the same sort of logic to get the desired output in your case..
Check in this way Hope it works...........
Cheers
Ajay
Hi,
I tried in another way to get the required o/p
=
Date(AddMonths((TODAY()),0),'YYYYMM') IT returns 201008
=
Date(AddMonths((TODAY()),-1),'YYYYMM') It RETURNS 201007
I think u need to implement the same sort of logic to get the desired output in your case..
Check in this way Hope it works...........
Cheers
Ajay