How do I calculate null values?

[Paknanarn23]

I want to calculate the null values ​​to get the following result

What do I need to do? I tried Nullcount(field) but it only counts numbers. I want to be sum

[sidhiq91]

@Paknanarn23  We are not able to understand your complete requirement. Could you please post some sample data and the expected output?

[Paknanarn23]

@sidhiq91  
I have the following information 

In my data table there are n/a values, so I would like to extract the sum of n/a like this.

Which if I use the nullcount formula, it's counting numbers which is not what I want

[sidhiq91]

@Paknanarn23  Please see the below code and let me know if it helps.

NoConcatenate
Temp:
Load Shift,
if(isnull(EmptyIsNull(MCDesc)),'No Value') as MCDesc,
Total

inline [
Shift,MCDesc,Total
Afternoon,,875
Day,,854
Night,,94
];

Exit Script;

[Paknanarn23]

Can I put this code in expressions

[Paknanarn23]

The total value is a value that changes every day.

[sidhiq91]

@Paknanarn23  The total value should not be a problem if it changes everyday. You can try the  expression in UI too.

[Paknanarn23]

I tried to do it but the value still doesn't come out.