JWT Calculate variables

[Nicolas Figueroa]

Hi all, 

I have a to make a little complex calculation.

I need to make  a calculation en base a numeric CustomField "Cant Pages" in a subtask, and show the total en in Epic, Standart Issue, it dosnt matter. But this sum need to take some variables. Cause i need to make the calculation in base of custom text field: "suppliers", between weeks. So the total need to show total pages by week and supplier.

I try this Function, but its drop down the server, lol.

sum(fieldValue("Cant Pages"})filterByFieldValue(filterByIssueType(getIssuesFromProjects("MG"), "Gestión con CL"), "Month", =, "Month") UNION filterByFieldValue(filterByIssueType(getIssuesFromProjects("MG"), "Gestión con CL"), "Week", =, "Week"))

Thx for your time.

[Jona Ittermann [Decadis AG] · Accepted solution]

Hi @Nicolas Figueroa

to be honest, I don't know, if I get your use case completely right. Could you maybe explain a bit more in detail what exactly you want to calculate and for which field values to you want to filter and how the result should look like?

Cheers

Jona

[Nicolas Figueroa]

Could delete the post?, cause I found other to do this. thx