I would like to see ALL measures entered on the custom screen to be able to be used in a calculation. I find myself defining columns (some with complicated selections) and then needing to define them all over again to use them in a calculation. And if you want to take the difference between two calculated fields you need to define them all over again in one giant calculation. It becomes very tedious and prone for errors.
6 Likes
I had search through Phocas topics, I am sure I have seen this elsewhere but alas not. Have liked this, as I have had some crazy formulas to workout in the past using the entire alphabet of custom metrics. Having some base custom calcs to reference would remove the complexity considerably.
I agree, it annoying that you cannot reference all columns. Custom mode is meant to enable a close proximity to Excel where obviously you can
1 Like