Inline Table

[drohm002]

Hi, I have a field called "Age" with values ranging from 1 - 10,000.  The age is in days.  I want to create a multibox filter with this field but I want the age to be displayed in years when the end user clicks the drop down.  So I need a way to categorize and say, 1 to 365 days = 1 year, 366 to 730 days = 2 years, etc.  Do I do this with an inline table, if so, how do I construct that?  thanks!

[sunny_talwar · Accepted solution]

May be like this

Table:

LOAD RecNo() as Age,

If(RecNo() <=730, Ceil(RecNo()/30) & ' month/s', Ceil(RecNo()/365) & ' year/s') as Flag

AutoGenerate 10000;