Forum Discussion

luis_pflucker's avatar
luis_pflucker
Icon for Helper II rankHelper II
4 years ago

not getting right values

Hi,  I am trying to calculate a column based in a measure but not getting as I want: Measure = sum(History[_ReTested (RFRT-Assigned) #]) Column 2 = if([Measure]=0,"0 reopened",if([Measure]=1,"1...
luis_pflucker's avatar
luis_pflucker
Icon for Helper II rankHelper II
4 years ago

Hi Goncalo,

I tried but no getting as I want, calculated column is:

_ReTested (RFRT-Assigned) # = if(and(History[History New Value]="Assigned",History[History Old Value]="Ready_for_ReTest"),1,0)
It is counting  but not differentiate 2 reopens, 1 reopens, etc.