Categories
Data Exploration & Discovery- Visual Analyzer Projects
Summary
Data Exploration & Discovery- Visual Analyzer Projects
Content
Hi team,
I am using oracle Visual Analyzer for creating some reports. But, I have an issue while applying one condition in a particular column to avoid the decimal values.
-10.00 ( Can you please help me with steps to change value to decimal level in a column)
Data column: I want to change date format YYYY-MM-DD. PFA the current output.
Thanks,
Venkata Kolla.
Answers
-
Hello Venkata,
1)>> Right click on the column with decimal values--> In the list of options select "Properties..."
>> Go to tab "#"(Value) --> change "Decimal" parameter value to "none"
2)
>> To calculate Date in YYYY-MM-DD format using date column you can make use of "Add Calculation" at the bottom of the Project
>> You can make use of Evaluate function as shown below to get desired format, and make use of new calculation column in your project instead of actual date column
Thanks and Regards,
Syed Hamd Salman
0 -
Hi Venkata,
If suggested steps helped you achieve your requirement then request you to close this thread as currently it is unanswered.
If above steps didn't help then please post back the steps you followed to resolve the issue and then close the thread!!:)
Thanks
0
