Is there any way to ask for/store user-entered var...
# suiteanalytics
d
Is there any way to ask for/store user-entered variable in a Saved Search? I am building a Transaction line item (Mainline=False) search that analyses Short Term vs. Long Term Revenue, defined as "1 year from date X". This is a moving target... my users want to see the effects of ST vs. LT on different dates. My solution has been to create different search for a handful of typical scenarios and code the Formula fields appropriately. Examples: - "one year from today" - "one year from 1st of the next month" (ie.. if today is Jan 6, ST/LT split is calculated at 1 year from Feb. 1) - "1 year from end of fiscal year", etc. It would be a lot easier if I could have the user enter an "ST/LT Split Date", or store that in a custom record/field. But where would I put that field and how would I query for it in a search? In Excel, it's simply stored in a cell off to the side of the data and the user can change it to whatever they want. The formulas just reference that cell.