How to use history value with two custom fields

Yatiraj Sharma

I am trying to use below formula in jira structure and selecting sum over sub-items but it is not working as it returns error with "VALUE!"
IF JQL {
"BRP/PI" != "Q1 FY 25/26" and committed in ("No", "TBC")
}:
history.changes.Filter(
$.field = "BRP/PI" and
$.fromText = "Q1 FY 25/26" and
($.changegroup.timestamp >= DATE('2025-04-07') and
$.changegroup.timestamp <= DATE('2025-06-30'))
).Filter(
history.changes.Filter(
$.field = "committed" and
$.fromText = "Yes" and
($.changegroup.timestamp >= DATE('2025-04-07') and
$.changegroup.timestamp <= DATE('2025-06-30'))
).size() > 0
).size()

Bo Zhao_a0vlc1

Hi Yatiraj,

Looks like you are trying some multi-layer filtering, especially a history.Filter within an upper layer Filter.

To narrow down the issue line, I'd suggest testing the filters inside out, just to pinpoint the issue layer by layer.