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)
Please log in to answer
Posted by:
chucksteel
3 years ago
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.
Comments:
-
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 3 years 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 3 years 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:
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) - chucksteel 3 years ago
Posted by:
prince0052
3 years ago
Press the <shift> key while having the input box focused. If I didn't know about it prior I'd end up having $$.
Comments:
-
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 3 years ago
