Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@Paknanarn23 We are not able to understand your complete requirement. Could you please post some sample data and the expected output?
@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
@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;
Can I put this code in expressions
The total value is a value that changes every day.
@Paknanarn23 The total value should not be a problem if it changes everyday. You can try the expression in UI too.
I tried to do it but the value still doesn't come out.