cancel
Showing results for 
Search instead for 
Did you mean: 

amount value display as without decimal values

0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

talia_gurevich
Participant
0 Kudos

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

0 Kudos

Hi Taila,

Yes ,if we change in the query level and apply in the VC its worked.

Regards,

Raju

Answers (2)

Answers (2)

Vasilis
Advisor
Advisor
0 Kudos

Hi,

try the expression ROUND(n) if the type field coming from BI is numeric or INT(str) if it is string

Regards,

Vasilis

former_member202465
Contributor
0 Kudos

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