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! Go to Solution.
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])
?
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])
?
tks you Aurelien. The problem was in [RINNOVO]=" " that it should have been ISBLANK([RINNOVO])
User | Count |
---|---|
56 | |
25 | |
13 | |
11 | |
6 |