Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I have a very simple expression to show the time from receiving data to it being ordered:
SendDate-OrderDate
this returns the time taken to order a product.
I have a situation where
day 1 - receive data
day 2 - ordered
SendDate-OrderDate = 1
day 3 New data received with the same PO Number
SendDate-OrderDate = -1
My question. is it possible in the expression to state 'if minus figure' display text like (New data received and not called off) for example.
Thank you for your help in advance.
Daniel
@davyqliks yes . you can do something like below
=if(SendDate-OrderDate<0,'NewOrder',SendDate-OrderDate)
@davyqliks try below
if(only({<locationcode={'UK'}>}Date_Order)-only({<locationcode={'UK'}>}[Send date])<0,'New Data Received and not called off',only({<locationcode={'UK'}>}Date_Order)-only({<locationcode={'UK'}>}[Send date]))
@davyqliks yes . you can do something like below
=if(SendDate-OrderDate<0,'NewOrder',SendDate-OrderDate)
wow, thanks for the quick reply, i'll give that a try and feedbacck.
thanks a lot Kush!
Hey Kush,
Thanks again for the below:
if(Date_Order-[Send date]<0,'New Data Received and not called off',Date_Order-[Send date])
I wonder, can you assist in adding the following set analysis to this:
{<locationcode={'UK'}>
I would expect it was placed after the first bracket but the syntax is not correct.
I am struggling to get this parameter into the expression above..,. can you help with this?
Thanks alot in advance.
Daniel
@davyqliks try below
if(only({<locationcode={'UK'}>}Date_Order)-only({<locationcode={'UK'}>}[Send date])<0,'New Data Received and not called off',only({<locationcode={'UK'}>}Date_Order)-only({<locationcode={'UK'}>}[Send date]))
Hey Kush,
This is great and will help me going forward, thanks so much.
Daniel