Month end data in straight table

[#1]

Hi,

can any body help how to get the last day sales of every month in one field in straight table

regards

Mahesh

[#2]

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)

[#3]

Let vMend = MonthEnd(Today()) and add based on the flag.