Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I had already had to make a relationship between a total (automatically calculated) and value.
I seem to have used the function dimentionality but can't remember how to apply it.
Could you help me?
Example:
Total (automatically calculated = 177
Value (count([PROGRESSIVO SEGNALAZIONE]) = 115
Fornula: Count([PROGRESSIVO SEGNALAZIONE]/ TOTAL and rapresent the result as a percentage
hi
to calculate share you can use this
count([PROGRESSIVO SEGNALAZIONE])/count(TOTAL [PROGRESSIVO SEGNALAZIONE])
Or may be this:
Count([PROGRESSIVO SEGNALAZIONE])/Count(TOTAL <PRIORITY> [PROGRESSIVO SEGNALAZIONE])
Read about The Aggregation Scope