icCube

Documentation

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.