This content has been marked as final. Show 1 reply
First of all you need to set day name in script like below
Then use script below
Load Location, Value, Date (floor(Date)),'DD/MM/YYYY' as LastDate, Date, Day (Date) as Day, MonthEnd (Date)as MonthEnd, MonthStart (Date) as FirstDay, MonthName (Date) as Month, Month (Date) as Month1, Year (Date) as Year, IF(Floor(Date) = Floor(MonthEnd(Date)),value,0) as LastDay, If(WeekDay(MonthEnd(Date))='Sun',0,Value) AS [LastDay2], If(WeekDay(MonthEnd(Date))='Sun',Previous(Value),Value) AS [LastDay3]; From .........