Hello, I'm looking into trying to set a value based on a difference between latest ship/fulfillment date and today with a parameter connected to a custom list created.
I'm using group summary on the rows and numeric formulas.
The custom list I'm trying to use has two types of fields
Integer number named in the fashion of
custrecord_spt_min_days_aging0 ect.
Precent fields in the fashion of
custrecord_spt_inv_aging0 ect
-----------------------------------
I'm starting in a item saved search and started with
Something like
CASE WHEN ({today}-{transaction.actualshipdate}) > {custrecord_spt_min_days_aging0} THEN ({totalvalue}*{custrecord_spt_inv_aging5}) ELSE 0 END
I have 2 problems in this.
1. I can't find the fields from the custom list to add to the formula that I'm trying in the search
2. When trying with just numbers in the cust fields I get Invalid expression in the search
Any ideas? Would be appreciated!