Sergio do Nascimento Posted April 24, 2019 Share Posted April 24, 2019 Hi all, I have a cross table with many columns with complex custom expressions. I want to do a new column that is a calc between two columns. Is there a way to refer a "column name" instead of repeat the expression Example Like this: Sum([field1) as [A], Sum([field2] as , [A] / as [C] Instead of this: Sum([field1) as [A], Sum([field2] as ,Sum([field1) / Sum([field2] as [C] Regards Link to comment Share on other sites More sharing options...
Sergio do Nascimento Posted April 25, 2019 Author Share Posted April 25, 2019 I used documentproperties to do that, but in some cases the expressions are too big to save as a string property... Property A = Sum([field1) Property B = Sum([field2) CrossTable expression: ${A},${B},${A} / ${B} Is there other way to do that Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now