Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I require help in identifying Median for Table Total in Row (highlighted in Blue). Shown sample below. please provide the QVW sample file for this. it would be a great help. Thanks in advance.
CUR | A | B | C | D | E |
USD | 10.00 | 8.00 | 13.00 | 6.00 | 14.00 |
INR | 58.00 | 56.00 | 61.00 | 54.00 | 62.00 |
EUR | 62.00 | 60.00 | 65.00 | 58.00 | 66.00 |
CZK | 35.00 | 33.00 | 38.00 | 31.00 | 39.00 |
Total | 165.00 | 157.00 | 177.00 | 149.00 | 181.00 |
Median for the total 165.00
In this case you need to extend the logic to ensure that the expression without available data didn't return 0 else null(). Quite probably you will need a check like: if(exp = 0, null(), exp). Just try the logic within a textbox with:
RangeFractile(0.5, 12,15,16,0) vs. RangeFractile(0.5, 12,15,16,null())
- Marcus