on 05-23-2013 7:17 AM
Dear All,
I am having a requirement like in my output table i want to display amount value shold come without decimal values(data is getting from bi query).
eg:currently 123.00
expt output 123
I am using Visual Compser for Netweaver 7.3 SPS 04.
Regards,
Raju
Hello Raju,
There is a possibility to define the number of decimal places of a key figure of the BI Query in Query Designer:
If you define there that the number of decimal places is 0, you will get the expected result.
Please note that after you change the Query in Query Designer you have to adjust the model in VC:
perform search for the query in VC, drag and drop the query again to the model and adjust all relevant lines and elements.
Regards,
Talia
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
try the expression ROUND(n) if the type field coming from BI is numeric or INT(str) if it is string
Regards,
Vasilis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raju,
A few questions - just so we're on the safe side:
- What is the Type of the field coming from the BI (String / Number)?
- What is the Type of the field in the table (String / Number)?
- Do you also need to allow editing of the value in the table?
Thanks,
Udi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.