How to write a previous month set analysis??

[jim_chan]

Hi guys,

i want to look for a previous month count. here my set analysis.

Count({$< Channel= {'TV1'}, Month(addmonths(max(master_date) ,- 1))}>}ID)

I think my set analysis is wrong.. i couldnt get any result. please help@!

Rgds

Jim

[prahlad_infy]

vMonth= (Month(Addsmonth(Today(),-1))

<Channel= {'TV1'}, Month_Field={'$(vMonth)'}>

[jim_chan]

i have added this

count(<Channel= {'TV1'}, month={'$(vMonth)'}>ID)

but stil not working.

[prahlad_infy]

send me sample data

[arvind1494]

Count({< Channel= {'TV1'},Month_Field= {$(=max(Month_Field)-1)}>}ID)

[Zhandos_Shotan]

Add equation before expression:

vMonth= '=Month(AddMonths(Max(master_date),-1)'

[sasiparupudi1]

You have to have a month period field .. Could you pl share a sample?

ex: if you have a filed that is in  NOV 2018  format,

=count({<Channel= {'TV1'},MonthYear={"$(=Date(AddMonths(Today(),-1),'MMM YYYY'))"}>} ID)

[sergioskv]

Hi!

Try this:

Count({$<Channel= {'TV1'},Master_date={">=$(=Addmonths(min(Master_date),-1))<=$(=Addmonths(max(Master_date),-1))"}>}ID)

Skvortsov S.