Forum Discussion
calculated column based on column content
modify to this :
cc = if( (tbl[PHASE NAME] = "Verification of Effectiveness" || tbl[PHASE NAME] = "Verification of Effectiveness approval") && selectcolumns( offset ( 1 , summarize ( tbl , tbl[PHASE NAME] , tbl[PHASE TICK_ID-1]) , orderby( tbl[PHASE TICK_ID-1] , asc ) , PARTITIONBY(tbl[INTERNAL_AUDIT_RESPONSE_NUMBER]) ), "@PHASE NAME" , tbl[PHASE NAME] ) = "Initial response" , "Failed VOE" )let me know if this helps /
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
write the following calculated column :
cc =
if(
(tbl[PHASE NAME] = "Verification of Effectiveness" || tbl[PHASE NAME] = "Verification of Effectiveness approval") &&
selectcolumns(
offset ( 1 ,
summarize ( tbl , tbl[PHASE NAME] , tbl[PHASE TICK_ID-1]) ,
orderby( tbl[PHASE TICK_ID-1] , asc )
),
"@PHASE NAME" , tbl[PHASE NAME]
) = "Initial response" , "Failed VOE" )
let me know if that works for you .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
modify to this :
cc = if( (tbl[PHASE NAME] = "Verification of Effectiveness" || tbl[PHASE NAME] = "Verification of Effectiveness approval") && selectcolumns( offset ( 1 , summarize ( tbl , tbl[PHASE NAME] , tbl[PHASE TICK_ID-1]) , orderby( tbl[PHASE TICK_ID-1] , asc ) , PARTITIONBY(tbl[INTERNAL_AUDIT_RESPONSE_NUMBER]) ), "@PHASE NAME" , tbl[PHASE NAME] ) = "Initial response" , "Failed VOE" )let me know if this helps /
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠i have added Phase Name to the summarize table as well. with that it works perfectly!! amazing, thank you!!