Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 12 Oracle Analytics Lounge
- 189 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 65 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to apply Sum on dollar values

How to apply Sum on dollar values
i have data as
c1 c2
jan $10
feb $20
Both c1 and c2 are varchar datatypes, how can apply sum on c2 which is varchar
since c2 is have $ sysmbol, im not able to cast this to integer
Anyone help
Answers
-
using Evalauate function, i have removed $ sysmbol. But i have having commas ',' in data ,so that unable to sum valaue. When tried to cast to integer got error.
Can someone help
0 -
Why EVALUATE? OBI Gives you a whole catalog of predefind functions which can easily do exactly what you're looking for:
cast(REPLACE('$1000', '$', '') as DOUBLE)
Or in your case:
cast(REPLACE("MyPresentationTable"."MyPresentationColumnWhereIWantThe$SignGone", '$', '') as DOUBLE)
0 -
Manu, did you let this drop or what's the status of your problem?
0 -
worked thanks
0 -
Good to hear. So can you please close this thread by marking the appropriate answers as "Correct" or "Helpful"? This will flag the thread as "Closed" and making it visible to other users that it contains a valid answer to the problem which helps when searching for a resolution in this forum.
0