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.

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.