Forum Discussion
luis_pflucker
Helper II
Helper IInot 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...
goncalogeraldes
Super User
Super UserHello there luis_pflucker ! SInce that is the case, use a "Calculated Column" with the same formula and I think you can get your desired result.
Hope this answer solves your problem! If you need any additional help please @ me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
luis_pfluckerHelper II
Helper IIHi 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.
- goncalogeraldes
luis_pflucker according to your print it is not counting but rather summing the values. Could it be that?
For additional help, please @ me in your reply!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes