Forum Discussion
admin11
Memorable Member
Memorable MemberHow to create expression for detect new product ?
Hi All
I got 2 fields.
- Last Sales
- Last Purchase Date
May i know how to write the expression , when :-
Last Sales = 00/00/0000 & Last Purchase Date not = 00/00/0000 is equal to new product
Hope some one can share with me.
Paul
Hi,
This calculated column formula works
New Product_final 1 = IF(and(INVC[Last Sales]=blank(),invc[Last Purchase Date]<>blank()),"New product","Existing product")Hope this helps.
12 Replies
admin11Thank you for sharing . i have try your propose code , it display Blank . Actual my condition , There is no sales for new product , Last Sales is 00/00/0000 , But There is Purchase date. As i indicate in Red below.
Last Sales = 00/00/0000 & Last Purchase Date not = 00/00/0000 is equal to new product
