Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have tried the approach but not able to show only those values in current month
which are not purchased on the last working day of previous month
and rest of the value of current month also should got exclude
I have tried belwo expression also
=IF(DATE<>'$(vPrevMonthLast)' AND Pur_Cd='Purchase',Only({$<DATE={">=$(vFromDate)<=$(vToDate)"}>} ID))
but above expression is taking current month ID also which i do not want
vPrevMonthLast=Need to take last working day of previous month'
PFA
Regards,
KK
am able to find out the last workin day of previous month but the logic which m trying is not working
When you say logic is not working what exactly is the problem?
wht is the variable value vTradeFrom
its is nothing jst startdate of my DATE filed
Can you share a sample you are working on? And also highlight the logic where you implementing this?