How to do a Macro in BEx Excel Analyzer
Does anybody have easy worksteps and the code to put in a Macro on an Bex Analyzer workbook.
I have a query on a workbook where there are blanks (e.g. no data) and I want it show zero. It's a payroll costing report and for crtain months against certain GL's there are no costings. It's not that the spreadsheet isnt showing zero's. It's that there physically is nothing against the Amount key figure for that month. So it's no good trying calculated key figures to get it to show zero. It cant show zero if there is no actual key figure for that month. I'm not supressing zero's and display zero's in turned on in Excel.
I want to use a macro in Excel to look at the query I've inserted and where a cell is blank I want it put in zero. I dont know how to use VB or Macro's so any worksteps and code etc would be much appreciated.