Skip to Content
0
Former Member
Mar 24, 2009 at 07:58 PM

Formula Variables and underlying characteristics

24 Views

I am using 2 formula variables based off of date characteristics in a calculated key figure. It appears that in order for the key figure to calculate correctly the 2 date fields have to be in the row. Unfortunately, I want to aggregate at a higher level than the dates. When I hide them, the key figures still break total at the date level. Is there any way of getting the key figure to calculate without the characteristics being in the row.

Any advice greatly appreciated.

Thanks

Bill