cancel
Showing results for 
Search instead for 
Did you mean: 

How to convert Text to numeric format in Webi when I have source as BW/HANA and running month

ujjani
Explorer
0 Kudos
245

Hi Everyone 
As per my requirement need to convert Text format to Number format 

Scenario 1:  I have an OCALMONTH object from the source system BW with a numerical data type. when we refresh the report the output of the OCALMONTH object on the Webi presentation layer will be in this format  OCT2024 07 (MonthYear date).

The expected output format is:  102024 07 

Please make a note of the following text:

When we refresh the report based on monthly values data, the OCALMONTH object should dynamically add 12 months to the column header.

 output value:

102024 -07112024 -08122024 -09
ujjani
Explorer
0 Kudos
Please help me change the column header dynamically and add it to a running 12-month result. based on the userresponse of Ocal-month Object values
View Entire Topic
ayman_salem
Active Contributor
0 Kudos

Define the following variable: 

v_Date:     =FormatDate(ToDate([Date]; "MMMyyyy dd"); "MMyyyy dd")

 (Note: [Date] object in my example = [OCALMONTH] object)

B_20241015_1.JPG

... 

I hope it helps

ujjani
Explorer
0 Kudos

Hi Salem

Thank you for providing the input to convert the Text format to a Numeric 

Please help me change the column header dynamically and add it to a running 12-month result. based on the userresponse of Ocal-month Object values