Set Analysis previous three month

[ceccannito]

Hi, Everybody,

i need to calculate a number of suppliers of previous three month

I have to build a table with three columsn:

First Column: city of Italy (FORN_UBICAZIONE_COMUNE)

Second Column: number of suppliers (FORN_COD)

Third Column: number of suppliers of previous three month (

=count({<FORN_DATA_INIZIO={"=$(=MonthStart(AddMonths(Max(FORN_DATA_INIZIO),-3)))"}>}FORN_COD)

but this code desn't work.

Can you help me?

Thanks a lot,

Lia

[dplr-rn]

What is the column FORN_DATA_INIZIO?

i am assuming from the code that its a date field and you are trying to get e.g. FORN_DATA_INIZIO=1 June 2018

if it is date try date(MonthStart(AddMonths(Max(FORN_DATA_INIZIO),-3))), 'YOURFORMAT')

[Zhandos_Shotan]

Hi!

Try to use:

=count(

{<

FORN_DATA_INIZIO={">=$(=MonthStart(AddMonths(Max(FORN_DATA_INIZIO),-3))) <MonthStart(Max(FORN_DATA_INIZIO))"}

>}

FORN_COD)

Best regards!