Forum Discussion
Comparison filters effecting sum
Please can anyone help me with the following formula. P- = 1 P =2 P+ =3 Pr2-Pr1 = (KS3[Prog Y8Pr2])-(KS3[Prog Y8Pr1]) I am trying to make this sum work on a page when you select any fil...
The filters are filtering columns with the letter P- , P, P+. and the PR1-Pr2 difference collumn is using a helper column I created using the numbers for the P-=1 P=2 P+ = 3 for each series PR1 and PR2.
IF(AND(KS3[Resultset]="Yr 8 PR1",KS3[P Helper]="P"),"2",IF(AND(KS3[Resultset]="Yr 8 PR1",KS3[P Helper]="P-"),"1",IF(AND(KS3[Resultset]="Yr 8 PR1",KS3[P Helper]="P+"),"3",IF(AND(KS3[Resultset]="Yr 8 PR1",KS3[P Helper]=""),"0"))))
What i think I need to create is some kind of formula using your if blank and something like this to convert the P-,P,P+ without the helper column?
IF(AND(KS3[Resultset]="Yr 8 PR1",KS3[P Helper]="P"),"2",IF(AND(KS3[Resultset]="Yr 8 PR1",KS3[P Helper]="P-"),"1",IF(AND(KS3[Resultset]="Yr 8 PR1",KS3[P Helper]="P+"),"3",IF(AND(KS3[Resultset]="Yr 8 PR1",KS3[P Helper]=""),"0")))) minus
IF(AND(KS3[Resultset]="Yr 8 PR2",KS3[P Helper]="P"),"2",IF(AND(KS3[Resultset]="Yr 8 PR2",KS3[P Helper]="P-"),"1",IF(AND(KS3[Resultset]="Yr 8 PR2",KS3[P Helper]="P+"),"3",IF(AND(KS3[Resultset]="Yr 8 PR2",KS3[P Helper]=""),"0")))) however i just cant work out the correct formula. 😞