search

afs1jes / Clarins-US-IR-Migration

0 stars 0 forks source link

Budget Input - Ecommerce P&L and GP #96

Open AVHuntley opened 1 year ago

AVHuntley commented 1 year ago

error message on server-build suggests missing data in header of one of the three grids called DataSet3. But same grids build client-side and seem to contain data in server-builds, suggesting they are running.

Likely the same issue as found on 'Budget Input - Direct Selling P&L and GP'

AVHuntley commented 1 year ago

Update to A3 resolved this issue, it seems.

Note to self: double check that all text columns are marked as not subtotaling. (Put "0" in the subtotaling format row in each column with a "1" in the comments format row.)

caroleszn commented 1 year ago

Hi I am getting the below error when running this template

Image

AVHuntley commented 1 year ago

I think that error was caused by a bug in A3 that has now been addressed. Can you try again?

caroleszn commented 1 year ago

Hi - I am having the same error again

caroleszn commented 1 year ago

Now works without error. I am experiencing a different issue on number format Row 41 and 42 of GP input tab should show numbers not percentages. I have tried changing the format of the template but it is still showing percentages and not numbers. Any idea how I can change the format? Thanks Carole

AVHuntley commented 1 year ago

Turns out you discovered a bug! It should be fixed now, in the most recent update to the A3 plugin.

The number formatting of the first row of every grid was being applied to the rest of the grid. That was causing the number formatting to be overwritten with percentage formatting.

This should be fixed on this template. Also, any future changes you make to the formatting should stick; they won't be overwritten.

It was the same issue on "Budget Input - Direct Selling P&L and GP." I'll go and make the same correction there in just a moment.

AVHuntley commented 1 year ago

Updated SQL grids on Sheet2 and TRANX to: 1) incorporate the 'combo' column into the grid, so it populates the formula from the default formatting row instead of needing to be pasted into the column. 2) created a new alias column to hold VALUE() of the Net Amount. This sidesteps and issue where numerical values returned to a SQL grid are interpreted as strings instead of numbers.