Converting Text to Numeric

Byron Burton shared this question 19 months ago
Completed

I tried using the Advanced functions, but it is not working. Can you give me some SQL?

Replies (9)

photo
1

Hello Byron Burton,

My name is Chegudi Priya from the Yellowfin Technical Support Team. We have received your support request, and I will be your primary contact on the following ticket:

Ticket Number: #32296-04-16
Case Title: Converting Text to Numeric

Request for Additional Information:

To better understand and expedite the resolution of your case, please provide me following details:

  • The info.jsp file for this instance in HTML format. In order to get this file please follow the instructions in the following link:

https://community.yellowfinbi.com/topic/how-to-get-the-info-jsp

  • A screenshot to illustrate the problem that you are facing
  • Have you tried using calculated fields?

Next Steps and Workarounds:


You may attempt the conversion using this method. I have included a video for your reference; please take a look and inform me if it is helpful or if you require any additional support.


Sincerely,

Chegudi Priya

Yellowfin Technical Support Engineer

This comment is in trash! Restore
photo
1

Impressive! Through changes to update escape road city 2 and learn to effectively use equipment programs. Explore and approach effectively.

This comment is in trash! Restore
photo
1

I already did that and it is not giving me exactly what I need. I need every item in the text field to be transformed into a numerical value so I can subtotal on it. I was hoping for a formula in the "Freehand SQL" that would transform the data. Is this possible?

All of the text is already formatted like this example "12.34"

This comment is in trash! Restore
photo
1

Hello Byron Burton,

Thank you for your patience, We have attempted to replicate the issue, and everything appears to be functioning as intended. Could you please share additional details, such as a screen recording or an Excel sheet outlining your expectations? This will help us determine whether we can provide further assistance.

We are happy to jump on a call to see the issue we can schedule this meeting between 06:30 AM IST to 1:30 PM IST. Please let me know your availability for the session and if you require any changes.

Sincerely,

Chegudi Priya

Yellowfin Technical Support Engineer

This comment is in trash! Restore
photo
1

I am trying the calcuated field. I was hoping for something like this. Yellowfin shows the message as valid sql but it does not work. Can you assist?

CAST("XX.PRELIM"."weight" AS DECIMAL(10, 2))
This comment is in trash! Restore
photo
1

Hello Byron Burton,

Thank you for your patience. We have attempted to replicate the issue, and everything appears to be functioning as intended. Besides exchanging email, we would like to jump on a short call to see the issue. We can schedule this meeting between 06:30 AM IST to 1:30 PM IST. Please let me know your availability for the session and if you require any changes.


Thanks & Regards,

Priya.

This comment is in trash! Restore
photo
1

Hello Byron Burton

I wanted to follow up with you regarding the session I requested in my last email. This will allow me to further troubleshoot this issue and work towards a resolution. I know you may be busy but this information is necessary to solve this issue.

Thank you,

Chegudi Priya

Yellowfin Technical Support

This comment is in trash! Restore
photo
1

No thank you. This finally worked. You can close the request.

41c3dc122f9721eaf05a5a5bd0718000



This comment is in trash! Restore
photo
1

Hello Byron Burton,

Thank you for confirming the closure. If you have any other issue please contact us again by opening up a new ticket and we will provide additional support.

Thanks & Regards,

Priya.

This comment is in trash! Restore
Leave a Comment
 
Attach a file