Subtotal Label Not Displaying

Question

We have an analysis that displays subtotals at each change in the Payment Date value.  The subtotal includes a custom label.

This works great as long as there is a payment date.  But some records do not have a payment date.  In this case the subtotals are correct; however, the label does not display.

Does anyone have a way to work around this?

Thanks,

Dennis

Jerry Casey · Answer

Thanks for the follow-up.  Glad it's working for you.

Dennis Hancy · Answer

As a follow-up to this conversation, I wanted to let you know that we ended up combining both of your suggestions into this one:

ifnull(EVALUATE('TO_CHAR(%1,%2)' as char,DATECOL,'fmmm/dd/yyyy'),'  ')

We did have one further complication in that this field contains an action link.  Since the screen it linked to was expecting a "date" data type (and not character), this caused a little grief.  But we got around that by adding a hidden payment date field that contains the actual payment date value and not a formula.

Anyway, this is all working as expected.  Thanks again for your invaluable input on this!

Dennis

Dennis Hancy · Answer

Thank you!!

My co-worker and I have been looking at this for the past hour or so when we saw your reply.  His words: This is the best answer ever!

It works like a champ.  Thanks again.

Dennis