pepfar-datim / Data-Pack-Feedback

1 stars 0 forks source link

KP Tab TX_PVLS Calculation incorrect #42

Open mariaau2222 opened 4 years ago

mariaau2222 commented 4 years ago

In the KP tab, the total number for TX_PVLS(N) is > TX_CURR I believe the issue is the formula in which TX_NEW is counted "twice" to calculate TX_PVLS among KP since TX_CURR already has TX_NEW embedded in the tabulation.

The current formula is the following: =IF(OR($B29="Female PWID",$B29="Male PWID",$B29="MSM not SW",$B29="MSM SW",$B29="TG SW",$B29="TG not SW",SUM($T29,$U29)<=0),"",ROUND(($T29$V29+$U29)$W29,0))

But I believe the CORRECT formula is to subtract TX_NEW once the calculation for %VL coverage for TX_NEW+% VLcoverage for TX_CURR is calculated to account for the fact that TX_NEW already is PART of TX_CURR

=IF(OR($B29="Female PWID",$B29="Male PWID",$B29="MSM not SW",$B29="MSM SW",$B29="TG SW",$B29="TG not SW",SUM($T29,$U29)<=0),"",ROUND(($T29*$V29+$U29 -$T29*)$W29,0))