Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Summarize data

Hi, I need output from my table like mentioned in the image. Kindly help me to get the solution.

 

General Comment
Need Help
Show and Tell
  • santiagomur's avatar
    santiagomur
    6 years ago

    hi, 

     

    try creating 3 calculate column.

    30 days=if(datediff(today();I-94 Valid To;DAY)>30&&datediff(today();I-94 Valid To;DAY)<=180;1;0)


    180 days=if(datediff(today();I-94 Valid To;DAY)>180&&datediff(today();I-94 Valid To;DAY)<=230;1;0)


    230days=if(datediff(today();I-94 Valid To;day)>230;1;0)

     

    I don't know the structure of your table, but this can give you an idea of ​​what to do.

1 Reply

  • santiagomur's avatar
    santiagomur
    Resolver II
    6 years ago

    hi, 

     

    try creating 3 calculate column.

    30 days=if(datediff(today();I-94 Valid To;DAY)>30&&datediff(today();I-94 Valid To;DAY)<=180;1;0)


    180 days=if(datediff(today();I-94 Valid To;DAY)>180&&datediff(today();I-94 Valid To;DAY)<=230;1;0)


    230days=if(datediff(today();I-94 Valid To;day)>230;1;0)

     

    I don't know the structure of your table, but this can give you an idea of ​​what to do.