Skip to Content
0
Jan 19, 2011 at 08:42 PM

Formula Variable and Exception Aggregation

38 Views

Hello

Please can you explain me how this works.

There is formula variable created on a change date.(Replacement Path) with replace with Key.

Then this formula variable is put in a formula as NODIM(Formula Var) and the exception aggregation is set as Total with Ref Char selected on the same date(Change Date).

Now this is coming up with values like 2202374. If i remove the exception aggregation then i get an X in the values. If i then include the change date in the rows i get the date.

Please can anyone let me know how this would be working. Effort Appreciated.

Thanks