search

afs1jes / Clarins-US-IR-Migration

0 stars 0 forks source link

Monthly actuals for Dept Sales #50

Open AVHuntley opened 1 year ago

AVHuntley commented 1 year ago

A difference in the way the new A3 version interprets leaf/rollup formatting caused all rows to format as non-leaves. Fixed by doing two things: -Pivoted [All Subaccounts] to the column headers. -Removed *[All Subaccounts] from both steps of the row script.

This will not affect the rows returns, but will allow A3 to correctly format leaf rows.

AVHuntley commented 1 year ago

Columns A and B both contained "hide" keywords, suggesting one was redundant. So I got rid of one and consolidated row headers.

Replaced manually hidden grid header rows with keyword "hide" (so that design/report view affects them).

Could possibly be improved by marking calculation columns as DoNotRead/Write.