Skip to Content
0
Former Member
Apr 13, 2010 at 04:38 PM

difference between dates in queries BW, the result key figure = X

305 Views

HI,

I have created a formula in a bw wanted, which is the subtraction of two dates.

I created two variables formula for each date and I subtracted.

When I run the report, and visulizo the data to a level of detail, breaking down in the lines of the report by a feature that is unique for all records, the result of the line I get the correct result of the subtraction of two dates.

But when I remove the breakdown, and the report I shows the cumulative total, the value shown in this ratio me = X. As in the total result of the report shows me an X.

As I can take this value?.

Thanks.