a month ago - last edited 3 weeks ago
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 -07 | 112024 -08 | 122024 -09 |
Define the following variable:
v_Date: =FormatDate(ToDate([Date]; "MMMyyyy dd"); "MMyyyy dd")
(Note: [Date] object in my example = [OCALMONTH] object)
...
I hope it helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
79 | |
10 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.