Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
can any body help how to get the last day sales of every month in one field in straight table
regards
Mahesh
Flagging the month end date in the script using the MonthEnd function and a simple set analysis expression in the straight table will perhaps produce the results you are looking for.
Script Example
IF(YourDate = MonthEnd(YourDate),1,0) as MonthEndFlag
Month End Sales Field
=SUM({$<MonthEndFlag={1}>}SalesAmount)
Let vMend = MonthEnd(Today()) and add based on the flag.