Hi Experts,
I created one Calculated Keyfigure
Previous Year Baseline:
PYBL >= 6 In Formula
In Aggregation Tab :
ExceptionAggregation : Total
Reference Charecterstic : CFBID
CFBID PCTR PYBL Month
100 202101 5.3 1
101 202101 5.3 1
101 202101 5.3 2
102 202101 5.3 1
103 202101 5.3 1
103 202101 5.3 2
I want to get 0
but I am Getting 2
CFBID PCTR PYBL Month
200 202101 7.3 1
201 202101 6.3 1
201 202101 6.3 2
202 202101 6.3 1
203 202101 7.3 1
203 202101 6.3 2
In this Case I am Getting Correctly as : 4
Can Any One Give Solution For This