Null formula - error in expression

[Tommmy]

Hi experts

the following formula is incorrect, the "isNull" seems not work. Any ideas?

sum({<isNull[Cost Center], [ Year]=, [ Month]=>} [Costs ])

[Lakshminarayanan_J]

@Tommmy 

Kindly post the sample data for reference .

[BrunPierre]

It's possible you are not having exactly null in the [Cost Center] field, maybe a blank. So try these

sum({<[Cost Center]-={"''"}, [ Year]=, [ Month]=>} [Costs ])

OR

sum({<[Cost Center]-={"'-'", [ Year]=, [ Month]=>} [Costs ])

[Tommmy]

Thanks Peter

But I need the "opposite" side. I have to calculate the value for cost centers without a "value".

The following code is not working:

sum({<[Cost Center]={"''"}, [ Year]=, [ Month]=>} [Costs ])

OR

sum({<[Cost Center]={"'-'", [ Year]=, [ Month]=>} [Costs ])

[Andrei_Cusnir · Accepted solution]

Hello,

Perhaps you can try: Sum({$-<[Cost Center]-={"''"}>}[Costs])

Outcome:

Value: 300 since it is the only value where Cost Center is null

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members. 

[BrunPierre]

In that case, check these out

How to calculate with NULL values included 

Handle NULL in calculation.