Median for Table Total Row

[Jack21]

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

[marcus_sommer]

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