Discussion board where members can get started with Qlik Sense.
TotOre = Ore lavorate + Delta
If Delta = 0 then I obtain making the sum I have result (red color)
if the value is null, the sum is invalid (green color)
How to create a function?
If I understand the question
sum(Ore lavorate) + sum(Delta)
Delta may assume 0 or null
If assume the value null, the sum is uncorrect
what's the result (ore + delta) you want when delta is null?
ore delta result you want
null 2 ?
null null ?
0 null ?
null 2 2
null null 0
0 null 0
I believe you want to use the RangeSum() function. This function will treat NULL values as 0. Try:
RangeSum(Ore lavorate, Delta)
ok, it works.
RangeSum(Ore lavorate, Delta) works because you are on the lowest level.
But if you want aggregate your data (group by a dimension or display a Total), you will need to use : RangeSum(sum(Ore lavorate), sum(Delta))
I updated the title of this post. Please be sure to include a valid question in the title to make it easier for other members to assist you. Feel free to update this one if you need to.
if it works, mark an answer as correct to help other and close your request.