Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
is this if else condition is fine??I do not get any value,getting blank,any suggestions
If
([VAR ETO] = 'ETO',
Today()-'RDDate',If([Item Category]='ZSPK' or 'ZSK1',today()-'GID of FPDdate',Today()-'GID of RDDdate'))
Thanks
Hi,
it looks like there are strings when there should be fields?
If ([VAR ETO] = 'ETO',
Today()-RDDate,If([Item Category]='ZSPK' or [Item Category]= 'ZSK1',today()-[GID of FPDdate],Today()-[GID of RDDdate]))
hope this helps.
Best regards
Stefan
Hi,
it looks like there are strings when there should be fields?
If ([VAR ETO] = 'ETO',
Today()-RDDate,If([Item Category]='ZSPK' or [Item Category]= 'ZSK1',today()-[GID of FPDdate],Today()-[GID of RDDdate]))
hope this helps.
Best regards
Stefan
try with
=
If([VAR ETO] = 'ETO',
Today()-[RDDate],
If( match([RDDate], 'ZSPK', 'ZSK1'), today()-[GID of FPDdate],
Today()-[GID of RDDdate]
)
)
Try this:
If([VAR ETO] ='ETO',Num(Today())-Num(RDDate),
If(Match([Item Category],'ZSPK','ZSK1'),Num(today())-Num(GID of FPDdate),Num(Today())-Num(GID of RDDdate)))
Regards
Av7eN
Thank you..looks good