QQ, how can I reference a formula field in saved s...
# suitescriptt
Tyn Guardian
03/27/2022, 2:38 PMQQ, how can I reference a formula field in saved search? I tried to add To_Number on the field but it did not work. Still returning Invalid Expression
b
battk
03/28/2022, 1:10 AMwhat does your column look like
t
Tyn Guardian
03/28/2022, 1:25 AMI have this formula on my field that I am referencing and this field as well is not stored value
{projectedtotal} * {custbody34} / 100
b
battk
03/28/2022, 2:13 AMstart at the column
battk
03/28/2022, 2:14 AMwhat does your search column look like
t
Tyn Guardian
03/28/2022, 2:25 AMI am trying to display the column name weighted project
Tyn Guardian
03/28/2022, 2:26 AMIn order for me to do that first I sourced the custom field and I add To_number function
Tyn Guardian
03/28/2022, 2:27 AMI might be able to remove the error Invalid:Expression, but per screenshot no 1 I'm not successful on displaying the value
b
battk
03/28/2022, 2:30 AMdont start with a formula column
battk
03/28/2022, 2:30 AMstart with a column that is just the weighted projection
t
Tyn Guardian
03/28/2022, 2:42 AMare you saying I will just call the custom field on my result?
b
battk
03/28/2022, 2:44 AMsearch columns have a list of available columns
battk
03/28/2022, 2:44 AMone of them should represent your custom field
t
Tyn Guardian
03/28/2022, 2:47 AMgot it. When I change my column here is what I get when I run
b
battk
03/28/2022, 2:49 AMso that suggests that your field doesnt actually have a valid formula in it
t
Tyn Guardian
03/28/2022, 2:50 AMbut when I check the form it shows value
b
battk
03/28/2022, 2:50 AMwhat does it look like on the record
t
Tyn Guardian
03/28/2022, 2:50 AMits like 1,200, numeric value
Tyn Guardian
03/28/2022, 2:51 AMI've read some article about referencing a formula field
http://www.netsuiterp.com/2018/09/error-invalid-expression-displaying-on.html
https://blog.prolecto.com/2012/10/24/netsuite-tip-formula-fields-referencing-other-formula-fields/
Tyn Guardian
03/28/2022, 2:51 AMbut It's still dont work on my end
b
battk
03/28/2022, 2:52 AMhardcode the formula on the field to 1
battk
03/28/2022, 2:52 AMand see if there is a difference
t
Tyn Guardian
03/28/2022, 2:55 AMLike this?
b
battk
03/28/2022, 2:56 AMstop using formula columns
battk
03/28/2022, 2:56 AMuse normal columns
t
Tyn Guardian
03/28/2022, 2:57 AMso how am i going to do this? "hardcode the formula on the field to 1"
b
battk
03/28/2022, 2:57 AMyou have a field and you have a column
battk
03/28/2022, 2:58 AMyou change the formula on the field
battk
03/28/2022, 2:58 AMand use a regular column to show the field
t
Tyn Guardian
03/28/2022, 2:59 AMah ok.. so when I change the formula value to 1.. and call the field on the saved search it just displays 1
b
battk
03/28/2022, 3:00 AMso now we have a working combination of field and column
battk
03/28/2022, 3:01 AMand now you slowly build up to what you wanted
battk
03/28/2022, 3:01 AMin this case, starting with {projectedtotal} as the formula on the field is a start
t
Tyn Guardian
03/28/2022, 3:03 AMok got it!
Tyn Guardian
03/28/2022, 3:04 AMfound the culprit {custbody34}
Tyn Guardian
03/28/2022, 3:28 AMthanks @battk
3 Views