Formula Variable Calculation behavior

Hello

There are 2 Variants I have attached below, which has been executed from a single Query.

One is by using 0CALDAY in Columns and other one without using 0CALDAY in the columns. (That means the Report selection parameters is from 23/11/2014 till 30/11/2014 in both the case)

KEY filed in this report is “No of Bins” . This has been calculated by using Formula Variable.

My requirement is, when I execute the report for above period ( 23/11/2014 till 30/11/2014) without using 0CALDAY in columns. The result should appear as 266,880 and not as 44,480. ( Since the KEY field is a Formula Variable it take the latest No of Bins Available and displays only 44,480 in Result)

In simple. I want the KEY field “No of Bins” should Sum up all the values from 23/11/2014 till 30/11/2014. And display 266,880

Requiring Expert Advice to acquire the desired result.

1) Variant 1

2) Variant 2

Thanks

Kumar