https://netsuiteprofessionals.com logo
Join Slack
Powered by
Hello all, just a quick question, I seem to have s...
# suiteanalytics
c
Hello all, just a quick question, I seem to have some trouble to get a function working. Would like to filter items where {Location Last Inventory Count Date}={Location Next Inventory Count Date}. For some reason I can't get the formula field to work.
Formula (Numeric) {locationlastinvtcountdate}={locationnextinvtcountdate} is 1 gives
Copy code
Your formula has an error in it. It could resolve to the wrong datatype, use an unknown function, or have a syntax error. Please go back, correct the formula, and re-submit.

Search: Item Search
Formula: {locationlastinvtcountdate}={locationnextinvtcountdate}
t
If actual date field, that formula should work. Dates = Numeric type
Instead of having them = each other, could you subtract one from the other
Yea, Subtract the next from last count date. Then your numerical value should be 0.
c
@TwoStep no we don’t use RFSmart. Thanks for the help. Let me give that a try.
that does not seem to work.
Copy code
Your formula has an error in it. It could resolve to the wrong datatype, use an unknown function, or have a syntax error. Please go back, correct the formula, and re-submit.
tried with numeric and date
fields are dates "30/09/2019"
t
Copy code
case when {firstfield} = {secondfield} then 1 else 0 end
Formula (Numeric) = 1
maybe that will work better for you. I don't really have any searches to help. Just off top of head.
Best of luck
b
subtraction usually works fine for dates
k
Might be benefiical to add some "floor" or rounding to it
if it's date/time it will have partial days
c
@TwoStep
Copy code
case when {firstfield} = {secondfield} then 1 else 0 end
Formula (Numeric) = 1
This works like a charm, thanks 🎉👍
👍 2
2 Views
Open in Slack
PreviousNext
Powered by