Avoiding empty dates while using Minimum aggregation

[Former Member]

Hello,

I've set the aggregation method to be Minimum for a date key figure. For a particular key value, if there are blank dates then it is displayed as the minimum value in the data target. I want the non empty minimum. I tried

setting

if not comm_structure-date_field is initial.

result = comm_structure-date_field.

endif.

in the update rule. but not working. I do not want to skip the record as there are other values in that record i would need.

please advice.

regs

Anoop

[somnathkumar · Accepted solution]

Hi Annop,

What about this logic.

If date_field is initial, result is 31/12/9999.

So if you have minimum aggregation, then the high date (31/12/9999) won't be considered at all.

In case they appear in your query, you could create a condition to filter them out.

[Former Member · Accepted solution]

Hi Somnath,

That's a very good option which I didn't think at all. Thanks and full points 2 u.

regs

Anoop

[somnathkumar · Accepted solution]

Hi Anoop,

Glad to know that it worked !! I thought about your problem for a long time on the back of my head and it suddenly struck me (EUREKA style ..)

Regards,

Somnath.

[Former Member]

hi!

why dont you try to debug the update rules?

lets see what it tells.

regards.

MM

[Former Member]

Hello,

By design, it is not supported to skip the updation of the key figures having Minimum aggregation. The RECORDMODE variable is not available.

In my situation, there are records where this date field is empty and hence will be selected as the miinimum field. What is the alternative to find out the non empty minimum of the date field key figure.

regs

Anoop