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
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)
Manu, did you let this drop or what's the status of your problem?
1 person found this helpful
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.