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
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?
worked thanks
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.
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher
How can you put a total number of records in your oracle OAC table footer
we have two seperate environments in air gap… 1- oas 2024 2- oas 2026 developers in both env, required extensions like push button, racing bar, guage…. where to download.
