Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
prajapatiamar38
Creator II
Creator II

Null Value?

Hi Experts,

I have 5 Fields in that each field have null value in it.I want sum of value of each field excluding null values.

How can I?

Plz Help Me...

Thanks

1 Reply
Gysbert_Wassenaar

You can use the rangesum function: rangesum(FieldA, FieldB, ..., FieldX) as SumOfFields


talk is cheap, supply exceeds demand