Relative graph

[cattaneoc]

Hello,

How can I convert the graphic attached to the image?

Thank you!

[swuehl]

As expression

Count(Poliza)

/

Count(TOTAL<Combustible> Poliza)

and format number as percentage on number tab

[cattaneoc]

Excellent! And could you rewrite the sentence if the dimension is a cyclic group?

[swuehl · Accepted solution]

Either add all field names that are part of the dimension group to the TOTAL qualifier field list or use GetCurrentField():

Count(TOTAL<Combustible, AnotherFieldName1, AnotherFieldName2> Poliza)

Or

Count(TOTAL<[$(=GetCurrentField( "Group Cyclico"))]> Poliza)

[cattaneoc]

It works! thank you very much. Why is the formula Underline in red?

[swuehl]

That's because the syntax checker can't really handle the dollar sign expansions $(=...)

It's a limitation of the checker, so you need to test the result yourself.

[cattaneoc]

Every day you learn something!

thank you very much