can not use total sum

[Anonymous]

Hi,

I set total mode on "Sum" for an expression1. I use expression1 inside an expression2, but the total value for expression2 is not correct.

I know I can use if(Dimensionallity()=0, ...  to further elaborate the calculation, but is there any way to directly refer to this total sum value?

Thanks.

[sujeetsingh]

Not clear about your question can you please come in with more words

[Anonymous]

Yes. I will try to explain it better.

I have a straight table with different expressions:

expressionA: =sum(...)

expressionB: =sum(...)

expression1: =if(expressionA>0, sum(...))

               For total mode I selected Sum. If not, the result is not correct.

expression2: =expressionB / expression1

               Results are right except for the total, where it is not using the value showed in the total of expression1.

I was wondering if there is any way to use the value shown in total of expression1 in the calculation of the total in expression2.

Thanks in advance.

[simenkg · Accepted solution]

expression2 = expressionB/sum({<Dimension={"=Sum(..)>0"}>}Field)

Where the Sum inside the set analysis should be ExpressionA and Field shuould be the Expression1 sum. The dimension should be the chart dimension.