Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

ottog85683
Community profile ottog85683 Level 1
Job title here
Location here
1 BADGE
Level 1

Level 1

Learn more
Joined the community 20-07-2017 2:29:16 PM
Offline
Top badges earned by ottog85683
Customize the badges you want to showcase on your profile
Re: Option to remove 0s in Report Builder data blocks
Avatar
Applaud 5
Level 1
ottog85683
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Applaud 5
View profile
ottog85683
- Adobe Analytics
This would only be partially heplful (i.e. when plotting completely raw data blocks), as there is an Excel bug that prevents any cell formula from returning a value that will be treated the same way as a truly empty cell by the chart functions. I once found a bizarrely complicated workaround, recommended by an Excel guru, that requires you to create a named range that refers to a list of calls to the Excel "indirect" function. (The named range is then explicitly specified as the data range for a...

Views

871

Likes

0

Replies

0
Re: Support Excel Client and Report Builder in Office 2010
Avatar
Applaud 5
Level 1
ottog85683
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Applaud 5
View profile
ottog85683
- Adobe Analytics
Excel Client does work in Excel 2010 32-bit under Windows 7 64-bit, but the "simple" interface for report publishing is broken. You get the confirmation box "Successfully scheduled report", but no report is scheduled. The workaround is to click the link to open the advanced scheduling window. Then it works, but it is necessary to log in again each time the advanced window is opened. This could also have to do with Internet Explorer 9, though. Or possibly antivirus software (deletion of authentic...

Views

12.6K

Likes

0

Replies

0