Forum Discussion

meghansh's avatar
meghansh
Frequent Visitor
1 year ago
Solved

Need help with calculated column

Hello everyone,   I need help creating a calculated column with the following data and conditions: ID Name Course Code End Date Result 12345 Robert Red 21-Mar-21 Pass 12345 Rober...
Need Help
Show and Tell
  • lbendlin's avatar
    lbendlin
    1 year ago
    Indicator = 
var i = [ID] var cc=[Course Code]
var a = Filter('Table',[ID]=i && [Course Code]=cc && [Result]="Pending" && ISBLANK([End Date]))
return if(COUNTROWS(a)>0,"Yes","No")
  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    Hi,

    This calculated column formula works

    Column = if(CALCULATE(COUNTROWS(Data),FILTER(Data,Data[ID]=EARLIER(Data[ID])&&Data[Course Code]=EARLIER(Data[Course Code])&&Data[End Date]=BLANK()&&Data[Result]="pending"))>0,"Yes","No")

    Hope this helps.

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi meghansh ,

Thanks for all the replies!
And meghansh , please check whether their solutions will help you solve your problem?
If solved please accept the reply in this post which you think is helpful as a solution to help more others facing the same problem to find a solution quickly, thank you very much!

Best Regards,
Dino Tao