Export Action doesn't work

DaGi07
Participant V

Hi to everyone,
i don’t figure out the reason why my action export doesn’t work. In particular, my action takes data from a slice with a row filter condition (AND(ISNOTBLANK([SCADENZA]), [SCADENZA] <= NOW(), [RINNOVO]=" ", [DIPENDENTE].[STATO]=“Attivo”)) in order to hav the data of expired course only for active employer but when i start action export, the data doesn’t appear in the csv file. What could be the reason?
tks to ALL!!
bye

Solved Solved
0 2 100
1 ACCEPTED SOLUTION

Aurelien
Participant V

Hi @DaGi07

Did your export used to work previously ?
Did you check if the slice provide any data first ?
There are many conditions, you may produce an empty slice:

AND(
  ISNOTBLANK([SCADENZA]), 
  [SCADENZA] <= NOW(), 
  [RINNOVO]=" ",
   [DIPENDENTE].[STATO]=“Attivo”
)

Moreover, your condition here:
[RINNOVO]=" "
has a space.
Do you want to use that instead ?
[RINNOVO]=""
or
ISBLANK([RINNOVO])
?

View solution in original post

2 REPLIES 2

Aurelien
Participant V

Hi @DaGi07

Did your export used to work previously ?
Did you check if the slice provide any data first ?
There are many conditions, you may produce an empty slice:

AND(
  ISNOTBLANK([SCADENZA]), 
  [SCADENZA] <= NOW(), 
  [RINNOVO]=" ",
   [DIPENDENTE].[STATO]=“Attivo”
)

Moreover, your condition here:
[RINNOVO]=" "
has a space.
Do you want to use that instead ?
[RINNOVO]=""
or
ISBLANK([RINNOVO])
?

DaGi07
Participant V

tks you Aurelien. The problem was in [RINNOVO]=" " that it should have been ISBLANK([RINNOVO])

Top Labels in this Space