Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
How can I convert the graphic attached to the image?
Thank you!
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)
As expression
Count(Poliza)
/
Count(TOTAL<Combustible> Poliza)
and format number as percentage on number tab
Excellent! And could you rewrite the sentence if the dimension is a cyclic group?
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)
It works! thank you very much. Why is the formula Underline in red?
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.
Every day you learn something!
thank you very much