Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

VIEW REQUESTS STATUS

HELLO, GUYS. I NEED TO DISPLAY THE QUANTITY OF REQUESTS BY STATUS, AS IT IS IN THE TABLE, A REQUEST CAN HAVE MORE THAN ONE PIECE AND IF ONLY ONE OF THEM IS APPROVED I NEED IT TO SHOW ME THE PARTIAL ...
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous ,

    a new column =

    var _cnt = countx(filter(Table, [request] =earlier( [request]) ), [request])

    var _cntA = countx(filter(Table, [request] =earlier( [request]) && [Status]="Approved" ), [request])

    return

    if(_cnt =_cntA , "Approved", "Partially Approved")

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous ,

a new column =

var _cnt = countx(filter(Table, [request] =earlier( [request]) ), [request])

var _cntA = countx(filter(Table, [request] =earlier( [request]) && [Status]="Approved" ), [request])

return

if(_cnt =_cntA , "Approved", "Partially Approved")