User empty rows as 0 value.


Author
Message
Alexander Kammerzell
Alexander Kammerzell
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)
Group: Forum Members
Posts: 8, Visits: 1

Hello,

I have the following data model in a List:

TitleValue [%]
A20
B
C30
A

Now I want to show the average value and use the empty values as 0-value. For example the AVG(Fields!Title) should be 

10 for A (=(20+0) / 2)
0 for B
30 for C

how can I bring it to work?

Regards,

Alexk


GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search