PercN (MDX+)
Returns the percentage of first parameter by the second one, empty if ANY of the parameters is empty or null or the second is equal to 0.
Parameters
| Name | Type | Cardinality | Default value |
| numeric-expression | one | ||
| numeric-expression | one | ||
| numeric-expression | zero-one |
Return
numeric-value
Description
This functions returns the percentage of first parameter by the second one.
PercN(A,B) = A / B - 1 ; empty if A or B are null/empty or B is equal to 0.
It will return the third parameter instead of null if the third parameter is defined (like a CoalesceEmpty).
See Also
AddN MinusN DivN CoalesceEmpty
Examples
Since Version
4.7
XMLA Properties
Find here the value of the XMLA properties when not specified otherwise.