[PBCS] Text Type Member is Updated with the Excel Formula Instead of Calculated Value In SmartView
(Doc ID 2257588.1)
Last updated on APRIL 01, 2019
Applies to:Oracle Planning and Budgeting Cloud Service - Version 17.02.75 and later
Information in this document applies to any platform.
If the data type of a column is text and you enter Excel formula to enter a calculated value in Smart View, the formula itself is set as a value instead of calculated value. Here is an example.
1. Create a sheet with two members in a row, a numeric type member and a text type member. In the following example, Capex:Land is a numeric type member and Comment is a text type member is in a sheet named Sheet 2.
2. Create another sheet which has two values. One is a numeric value and the other is text value. In this example, 100 and aaa are in a sheet called Formula.
3. Go back to the sheet created in step1 and enter an Excel formula in a numeric type member to refer the value created in step2. In this example, Formula!B1 is entered as the value of Capex:Land.
4. Click Send. You will notice that the value of the numeric type member is updated by the calculated value.
5. Enter an excel formula in a text type member to refer the value created in step2. In this example, Formula!B2 is entered as the value of Comment.
6. Click Send. You will notice that the value of the numeric type member is updated by the Excel formula itself.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document