KACE Product Support Question

Is it possible to put a dollar value in a field

07/14/2020 171 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


Community Chosen Answer


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:
      SUM(CONVERT(CUSTOM_FIELD_VALUE7, decimal(10,2)))
      WHERE HD_QUEUE_ID = 11

All Answers


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 Yellow 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?
This content is currently hidden from public view.
Reason: Member has been banned from the site commercial For more information, visit our FAQ's.

Don't be a Stranger!

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

Sign up! or login


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