Set Analysis - Division issue

[bhargavikn]

Hello,

I'm new to QlikSense and I'm trying to achieve the expected result with set analysis. but I'm unable to. could you please help me on this.

Sample:

Measure:

Num(
Fabs(
(Sum({$<Year=, [Month Year]=>} Field1*Flag)
- Sum({$<Year=, [Month Year]=>} Field2*Flag))
/
(Sum({$<Year=, [Month Year]=>}Field3*Flag)
+ Sum({$<Year=, [Month Year]=>}Field4*Flag))
)))

Actual Result:

Test	FY 2019 – VALIDATED	FY 2019 – ACTUAL	FY 2019 – VALIDATED vs ACTUAL
Data	277.80	286.71	434.37

Numerator
Test	FY 2019 – VALIDATED	FY 2019 – ACTUAL	FY 2019 – VALIDATED vs ACTUAL
Data	-12,040,369,761.54	-13,176,043,339.57	1,135,673,578.03

Denominator
Test	FY 2019 – VALIDATED	FY 2019 – ACTUAL	FY 2019 – VALIDATED vs ACTUAL
Data	43,341,367.21	45,955,869.51	-2,614,502.30

Expected Result
Test	FY 2019 – VALIDATED	FY 2019 – ACTUAL	FY 2019 – VALIDATED vs ACTUAL
Data	277.80	286.71	-8.91

The value in 'FY 2019 – VALIDATED vs ACTUAL' should work with Flag used, not with the division.

attached sample data for reference. Please help me with the suitable expression.

Thanks a lot in advance.