Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
Hi!
Try to use:
=count(
{<
FORN_DATA_INIZIO={">=$(=MonthStart(AddMonths(Max(FORN_DATA_INIZIO),-3))) <MonthStart(Max(FORN_DATA_INIZIO))"}
>}
FORN_COD)
Best regards!