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))
if it works, mark an answer as correct to help other and close your request.
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.
Retrieving data ...