Monthly Presentation Package

afs1jes / Clarins-CA-IR-Migration

0 stars 0 forks source link

Monthly Presentation Package #26

Open AVHuntley opened 1 year ago

afs1jes commented 1 year ago

Column N on Balance Sheet tab is not part of a grid.

rlautt commented 1 year ago

IR 15 sec

FrederickGiroux commented 1 year ago

I think this report is build with ''current year'', could you change it to have a selection for years so i can see if it works properly with the YR 2022 data?

AVHuntley commented 1 year ago

Okay I did two things:

Added the selectable Year (Financial::Finance) to the template
Ctrl-F find-and-replace "SystemCurrentYear" with "SelectYear" throughout the workbook

The Year selectable defaults to CurrentYear, so you can get the original results by accepting the default member for that selection.

Possible room for improvement - changing this formula to avoid huge percentages:

FrederickGiroux commented 1 year ago

Hey Alec,

Ok you can change the formula. FYI, i just realized we only use the first sheet now. The spacing is too wide. I know Jim might have found a way to help, i will look at the spacing with him monday

AVHuntley commented 1 year ago

I copied the column widths from the prod version, so those should match exactly now.

As for the formula, I'm not sure off hand what it should be, and I hesitate to change it without understanding it better. Leaving it for now.