Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers