SYMPTOM
If a user creates a metric using the InverseNormDistribution in Strategy Developer, it returns no data. All metrics used for calculating InverseNormDistribution show correct results, as shown below:
CAUSE:
The InverseNormDistribution function uses three metrics:
The metric named 'x' in the above example is described as a probability corresponding to a given normal distribution. For that reason, it should have values between 0 and 1 inclusive. If its values are below 0 or above 1 the InverseNormDistribution function returns no result.
ACTION:
Ensure that the 'x' metric has values between 0 and 1 inclusive. The InverseNormDistribution metric will show non null values, as shown below:
