How to show only vaule for the last week of the month

[amit_saini]

Hi Folks,

How to show value only  for the last week of the month

Thanks,

AS

[jpenuliar]

try:

=Weekname(MonthEnd(today()))

[robert_mika]

Could you share your data/layout?

[Anonymous]

Hi

if it is some calculation for last week of every month

then you can use

if(week=Week(MonthEnd(Datecol)),sum(col1))

PS : week =  week no column column in your datamodel