Summaries ranges

[Joe1010]

In have a filed Cost, Aged, and Item
Each Item cam be in multiple aged fields

I would like to create a report that summaries total cost by aged range. It should be incremented by180
Like 180-359, 360-539, 540-719

How can this be done?

Do I have to create a sum field for each Aged Like 180, 360, 540?
Thanks
Joe

 

[lbass]

Try creating a formula like:

if {table.aged} in 0 to 179 then "0 to 179" else
if {table.aged} in 180 to 359 then "180 to 359" else //etc.

Then insert a group on this formula. Then you can right click on your cost field and insert a summary at the aged group level.

-LB

 

[Joe1010]

Great, Thanks

Another stupid question no related to the above..
Every item has 3 fields, price1, price25, and price,
What is the function for my custom filed to show the Min price for each item?
Thanks

 

[lbass]

Use this formula to find the minimum of a set of fields in the same detail row:

minimum([{table.price1},{table.price25},{table.price}])

-LB