/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Is it possible to put a dollar value in a field

07/14/2020 116 views

I have a series of fields where we want to accumulate the cost of an item. Hence this requires $$.cc 


If I use the number format for a custom field it does not allow this. What format should I use if also want sum these values into a total field. 



0 Comments   [ + ] Show comments

Comments



Community Chosen Answer

1

You should be able to use a number field, although you won't be able to include the dollar sign as part of the value, just the numeric value. If that doesn't work, then you can use a text field and still perform the sum in a custom report query.


Answered 07/15/2020 by: chucksteel
Red Belt

  • Thanks for that.... that is the conclusion I came to. I wasn't wanting to use the dollar sign but it only lets you use integers so i cant use 0.00 format.
  • Set all my number fields back to text but the corresponding SQL required to massage a text field into a number before you can add it is substantial. I would like to suggest a modification I think.
    • How are you trying to sum the values? Our purchasing queue uses a text field (CUSTOM_FIELD_VALUE7) for the asset price and the following query works to get a total of purchased items for the year and month:
      SELECT YEAR(CREATED), MONTH(CREATED),
      SUM(CONVERT(CUSTOM_FIELD_VALUE7, decimal(10,2)))
      FROM ORG1.HD_TICKET
      WHERE HD_QUEUE_ID = 11
      GROUP BY YEAR(CREATED), MONTH(CREATED)

All Answers

0

Press the <shift> key while having the input box focused. If I didn't know about it prior I'd end up having $$.

Answered 07/15/2020 by: prince0052
Senior White Belt

  • So the field has to be a text field? I cant use a number field. Also I want to flood the field with the cost per item from the asset record?
0

You need to press the SHIFT key while adding text to the field.

Answered 07/16/2020 by: aakshitr1
Orange Belt

  • Just tried it. It needs to be a text field. That raises problems when I am trying to total up several cost fields - there is a very long convoluted SQL to take each number and translate. It would a lot easier if I could put 2.33 (e.g.) into a number field

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ