Set Field Calculation
I am attempting to use an escalation to perform a set field action using mathematical calculation. From reading the documentation it seems that I should be able to do this, but I can't seem to get it work. I want to do something like: Name: Testfield Value: Field1 / 100 Field1 is a Real Number field, Testfield is Character field. Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Set Field Calculation
When you do the set field do you have it as: $Field1$ / 100 OR $Field1$ + / 100 The 2nd one the system will definitely see as concatenation not a mathematical function. Also, why can't Testfield be a real number also? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Monday, November 14, 2011 7:47 AM To: arslist@ARSLIST.ORG Subject: Set Field Calculation ** I am attempting to use an escalation to perform a set field action using mathematical calculation. From reading the documentation it seems that I should be able to do this, but I can't seem to get it work. I want to do something like: Name: Testfield Value: Field1 / 100 Field1 is a Real Number field, Testfield is Character field. Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Set Field Calculation
I have it like your first example. I was just reusing an existing test field I had thinking a character field would be ok, but I will try a Real Number field to see if that is causing a problem. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pargeter, Christie :CO IS Sent: Monday, November 14, 2011 9:50 AM To: arslist@ARSLIST.ORG Subject: Re: Set Field Calculation ** When you do the set field do you have it as: $Field1$ / 100 OR $Field1$ + / 100 The 2nd one the system will definitely see as concatenation not a mathematical function. Also, why can't Testfield be a real number also? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Monday, November 14, 2011 7:47 AM To: arslist@ARSLIST.ORG Subject: Set Field Calculation ** I am attempting to use an escalation to perform a set field action using mathematical calculation. From reading the documentation it seems that I should be able to do this, but I can't seem to get it work. I want to do something like: Name: Testfield Value: Field1 / 100 Field1 is a Real Number field, Testfield is Character field. Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Set Field Calculation
Hi, The problem is that the contents go to a text field, so if you want to do maths, you need to go via a numeric field: Set-Fields 1: tmpreal = $Field1$ / 100.0 Set-Fiedls 2: Testfield = $tmpreal$ Or maybe you can do something like this: Set-Fields: Testfield = ROUND($Field1$ / 100.0) Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. I have it like your first example. I was just reusing an existing test field I had thinking a character field would be ok, but I will try a Real Number field to see if that is causing a problem. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pargeter, Christie :CO IS Sent: Monday, November 14, 2011 9:50 AM To: arslist@ARSLIST.ORG Subject: Re: Set Field Calculation ** When you do the set field do you have it as: $Field1$ / 100 OR $Field1$ + / 100 The 2nd one the system will definitely see as concatenation not a mathematical function. Also, why can't Testfield be a real number also? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Monday, November 14, 2011 7:47 AM To: arslist@ARSLIST.ORG Subject: Set Field Calculation ** I am attempting to use an escalation to perform a set field action using mathematical calculation. From reading the documentation it seems that I should be able to do this, but I can't seem to get it work. I want to do something like: Name: Testfield Value: Field1 / 100 Field1 is a Real Number field, Testfield is Character field. Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Set Field Calculation
Thanks... The Real Number field fixed it. I assumed that a character field would work since it could hold any text/numbers, but I was obviously wrong. Thanks again. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Monday, November 14, 2011 10:26 AM To: arslist@ARSLIST.ORG Subject: Re: Set Field Calculation Hi, The problem is that the contents go to a text field, so if you want to do maths, you need to go via a numeric field: Set-Fields 1: tmpreal = $Field1$ / 100.0 Set-Fiedls 2: Testfield = $tmpreal$ Or maybe you can do something like this: Set-Fields: Testfield = ROUND($Field1$ / 100.0) Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. I have it like your first example. I was just reusing an existing test field I had thinking a character field would be ok, but I will try a Real Number field to see if that is causing a problem. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pargeter, Christie :CO IS Sent: Monday, November 14, 2011 9:50 AM To: arslist@ARSLIST.ORG Subject: Re: Set Field Calculation ** When you do the set field do you have it as: $Field1$ / 100 OR $Field1$ + / 100 The 2nd one the system will definitely see as concatenation not a mathematical function. Also, why can't Testfield be a real number also? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Monday, November 14, 2011 7:47 AM To: arslist@ARSLIST.ORG Subject: Set Field Calculation ** I am attempting to use an escalation to perform a set field action using mathematical calculation. From reading the documentation it seems that I should be able to do this, but I can't seem to get it work. I want to do something like: Name: Testfield Value: Field1 / 100 Field1 is a Real Number field, Testfield is Character field. Andy L. Mayfield Alabama Power Company Protection Control Technician Sr. Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1805 _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
