Skip to Content
0

Get the First Non null value in a row in webi report

Mar 22, 2017 at 07:47 PM

41

avatar image
Former Member

I've a cross tab report with date in the row and range of dates in the column and the body of the table contains the trend of revenue over the months. My challenge here is to get the first non null value in that range. For example:

Month Jan Feb Mar Apr May ....

Jan 10 15 20 25 30 ...

Feb 20 30 40 50 ...

Here If I use First() function , i'll get 10 for Jan and Null value for Feb , instead I want 10 for Jan and 20 for Feb . Tried using different where clauses but didn't get the result. Looked in the forum everywhere to find it. Please help me out

10 |10000 characters needed characters left characters exceeded

can you share the screenshot?

1
Former Member

capture.jpg

Need first non null value from every row in that list

capture.jpg (98.3 kB)
0
* Please Login or Register to Answer, Follow or Comment.

0 Answers