CODEWITHSUNDEEP
business-objectswebi
shazma
shazma

Reputation: 55

SAP - Web intelligence Cell Reference

I have created 7 cell references in WEBI with the purpose of averaging seven cells (for a week), the referenced cells contains a percentage value eg 99.25%. However, when I calculate an average on the referenced cell I always return a 1, so it seems the referenced cell is storing as a 1 rather than 99.25%

Any ideas how to navigate this?

Thanks

Upvotes: 0

Views: 602

Answers (1)

Mark
Mark

Reputation: 61

You need to format the cell. The percentage is being held as 0.9925 and rounding to 1. Right-click on the cell and change the number format to a percentage to make sure this is the case, then fine tune it to display exactly how you want if needed.

Upvotes: 1

Related Questions