Is it possible to put a dollar value in a field

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

Answers (2)

Posted by: chucksteel 9 months ago
Red Belt

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.

  • 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. - kiwiblue 9 months ago
  • 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. - kiwiblue 9 months ago
    • 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
      GROUP BY YEAR(CREATED), MONTH(CREATED) - chucksteel 9 months ago
Posted by: prince0052 9 months ago
Senior Yellow Belt

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

  • 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? - kiwiblue 9 months ago

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