Having a lot of trouble coming up with formula that will allow MINOF Date to be calculated across 4 Detail tabs, where it's possible to have no entry on 1 or more of the tabs.
This formula works fine if each of the referenced tabs has an entry...
If one of the tabs doesn't have an entry, then we get the 1/1/1970, 12am return.
I have tried all manner of IF statements to only apply MINOF to tabs that have valid entries, and it seems MINOF does not handle nested formulas fully to end up with api field names. I cannot get any combination of these to work -- for example, the following only returns the MinOf the last tab's Start Date and Time Field even though all are filled.
I'm hoping to be missing something terribly obvious here!
What if you used a nullif or isnull and set the value to a NOW timestamp so that you still returned the MIN
Hi Scott - it seems MINOF only accepts <tab name> as defaulting to $F.NOW() if null always overrides result to NOW().
Is there a target field that is also the same format? Correct me if I am wrong but you want the overall minof any of the declared line types?
That's correct - same type. We have no issue filling from one tab via MinOf, or from multiple tabs with MinOf by using a list of $D.XXXXX tabs if they ALL have entries. Where the problem comes is where we have a null value on one of the tabs. Using an IF and trying to omit a null value doesn't seem to work in any combination -- I either end up with 1/1/1970, NOW(), or a MINOF just one of the tab values, depending on how I structure the formula. I tried every conceivable way of doing this (to me), short of writing out IF statements for 4! combinations.
Also, what type of SFM is it? Standalone to edit existing records? Forgive me for the sporadic questions. I am just trying to make sure I am processing the most accurate set of variables.
Much appreciated. Standalone for editing existing record. Header Object is Work Order, and Tabs are Work Detail of different qualifying criteria. We have a bunch of dependent rules and such which makes the tabs necessary.
Which data model are you guys using? Work Order with multiple Products Serviced lines or Parent Child work order record types with a single Installed Product per child work order? Does this apply to all line types or just the ones specified at the beginning of this thread?
Trying everything just short of using duct tape, it seems that the Formula editor would certainly benefit from isnulls, nullifs, or where clauses.
With that being said, SFDC handled it well. I subbed your line types for what we had in the box I was working out of.
In the filter criteria, I used "not equal to" to pass on null values. It's a shame that the SFM formula throws a 0 when theres no record.