Hardcode 'down total' formula to prevent it from referring to another block.

Waleed Ullah

Hi,

I've been having an issue where my 'Sales Mix (%)' calculation refers to a moving block from the layout, instead of maintaining the 'down total' function.

To calculate 'Sales Mix (%)', I am using the algorithm: (Sales/Down Total (Sales))*100 or c/dt(c)% in the below example. The issue I am having is that the data view layout is relatively large and runs to block 'ey', and whenever a block is adjusted/moved, the algorithm follows the block 'dt' (repositioned to block 'dv' in the image) instead of recognising it as the 'down total' function, and therefore returns no values as the algorithm is now incorrect.

I'd suggest to add a way to hardcode the block, possibly by using wildcards, to recognise 'dt' and other similar functions as a function instead of a block.

Thanks,

Waleed

Edward Ervin

@Waleed Ullah If you use Capital Letters the block reference doesn't change if you move blocks around

Waleed Ullah

@Edward Ervin Ah thank you, I didn't know that