https://netsuiteprofessionals.com logo
t

Tyn Guardian

03/27/2022, 2:38 PM
QQ, 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 AM
what does your column look like
t

Tyn Guardian

03/28/2022, 1:25 AM
I 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 AM
start at the column
what does your search column look like
t

Tyn Guardian

03/28/2022, 2:25 AM
I am trying to display the column name weighted project
In order for me to do that first I sourced the custom field and I add To_number function
I 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 AM
dont start with a formula column
start with a column that is just the weighted projection
t

Tyn Guardian

03/28/2022, 2:42 AM
are you saying I will just call the custom field on my result?
b

battk

03/28/2022, 2:44 AM
search columns have a list of available columns
one of them should represent your custom field
t

Tyn Guardian

03/28/2022, 2:47 AM
got it. When I change my column here is what I get when I run
b

battk

03/28/2022, 2:49 AM
so that suggests that your field doesnt actually have a valid formula in it
t

Tyn Guardian

03/28/2022, 2:50 AM
but when I check the form it shows value
b

battk

03/28/2022, 2:50 AM
what does it look like on the record
t

Tyn Guardian

03/28/2022, 2:50 AM
its like 1,200, numeric value
but It's still dont work on my end
b

battk

03/28/2022, 2:52 AM
hardcode the formula on the field to 1
and see if there is a difference
t

Tyn Guardian

03/28/2022, 2:55 AM
Like this?
b

battk

03/28/2022, 2:56 AM
stop using formula columns
use normal columns
t

Tyn Guardian

03/28/2022, 2:57 AM
so how am i going to do this? "hardcode the formula on the field to 1"
b

battk

03/28/2022, 2:57 AM
you have a field and you have a column
you change the formula on the field
and use a regular column to show the field
t

Tyn Guardian

03/28/2022, 2:59 AM
ah 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 AM
so now we have a working combination of field and column
and now you slowly build up to what you wanted
in this case, starting with {projectedtotal} as the formula on the field is a start
t

Tyn Guardian

03/28/2022, 3:03 AM
ok got it!
found the culprit {custbody34}
thanks @battk