cancel
Showing results for
Did you mean:
Highlighted
New Member

## Summarize data

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

1 ACCEPTED SOLUTION

Accepted Solutions
Member

## Re: Summarize data

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.

Member

## Re: Summarize data

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.

Announcements