[NatalieLynn]

I have a search created and I am trying to enter a formula from the results. Example: the search pulls the Sales Order, Date, Freight Cost and Amount (shipping). I want to take Freight cost – Amount shipping and get a number. I have tried this a few times and it always tells me the formula is incorrect. Can anyone help?

Thanks
This is a cached copy. Click here to see the original post.

[evan_goldberg]

RE: Formulas

Can you show us what you have tried?

[NatalieLynn]

RE: Formulas

{custbody_rposfreightcost}-{shippingamount} is equal to or greater than 0

I used a numeric formula…..this is all under criteria.

Am I doing this wrong?

[evan_goldberg]

RE: Formulas

That looks right to me. Is custbody_rposfreightcost a currency custom field?

[NatalieLynn]

RE: Formulas

I dont believe it is…I set it up and don’t remember picking that. How do I set that?

[evan_goldberg]

RE: Formulas

Well, if you set it up as free form text then you don’t want to change it – you will lose the data. What you can do is set up a new field that is type currency and copy the value over using a formula in a mass update. However you could leave it as free form text and change your formula to use to_number({custbody_rposfreightcost})-{shippingamount}

[K.Izer@IslandSurf.com]

RE: Formulas

I have a question…

You are trying to get a result… correct?

if this is your formula:

{custbody_rposfreightcost}-{shippingamount} is equal to or greater than 0

you shouldn’t have the option to set is equal to or greater than 0 when entering it as a result. You should just enter the equation part: {custbody_rposfreightcost}-{shippingamount}.

[NatalieLynn]

RE: Formulas

Ok I created a new field and now want to do the mass update. How do I do that?

[NatalieLynn]

RE: Formulas

I know where to go to do the mass update, I just dont know the exact steps once I get there. Can you tell me the steps so I can do it?

Thanks

[evan_goldberg]

RE: Formulas

Do a general update for the transaction type you are working with (Sales Order?). Under the fields tab, click the checkbox next to the new custom field, then enter a formula of to_number({custbody_rposfreightcost}) in the formula field.

Preview the update then run.

Thanks,

-e

[NatalieLynn]

RE: Formulas

It is not performing the update….Let me tell you step by step what I am doing:

Once I am at the general update (RMA) for I go to the mass update tab, then I check the box that says RPOS Freight (the new field I created) then in the formula I write to_number{custbody_rposfreightcost}

what am I missing????

[evan_goldberg]

RE: Formulas

looks like you might be missing the parens around the curly braces?

[Author]

Posts