aggr result in a text box

[#1]

Hello All,

Below is the scenario

There is a date field D1. Each record is to be subtracted from today() and the difference is to be summed up.

The sum is to be shown in a text object.

Please help with the possible solution

Regards,

Priya

[#2]

Hi All

There are lot many dates and not just two.

However, i got the solution.

           =sum(aggr(today()-D1,D1)) .

Previously i was trying with sum first and then aggr on top of it, hence couldnt get the required result.

Thank you for your time.

[its_anandrjs]

Hi,

Better you use

=Sum( Aggr( Interval(Today() - D1,'D'), D1))

Regards

Anand