sum of If statement

[Rfoot]

Hello,

I have this if statement below. The logic is great but why does it only sum up the [GL Budget $]? 

IF(isNull([JC Job Desc]), [GL Budget $], num(sum(distinct [Max Cost Budget Closing]),'#,##0.00;-#,##0.00'))

I would expect it to sum up all values in the column calculated by the if statement.

FYI: [GL Budget $] is a measure that sums all the gl budget while [Max cost budget closing] is a field

Thank you

[hic]

Because there are probably multiple values of [JC Job Desc], and then it is evaluated to NULL. So your condition is always true.

Wrap [JC Job Desc] in an aggregation function.

See more on https://community.qlik.com/t5/Design/Use-Aggregation-Functions/ba-p/1475833