I have an interactive report. There’s a field on the table called “Promise Date”. I want to display a calculated field called “Days Overdue”. Days Overdue would be Promise Date - Today . Is there a way to do this without having to actually add new fields to the table?
IR generally doesn’t support date math, so unfortunately if it is not something that is seeming to work, then it’s likely not supported. You could run it by Garrett to confirm. We’ve gotten “lucky” and noticed some very specific date math does work but in general it’s not a supported feature so I would not expect what you’re describing to be possible without a logic block.