Field To Keep

[k_burata]

Hi All,

Have his set analysis below where in I ignore all selection except [Payment Group] Field. Problem is I want [Payment Group] to be less than and not just equal to. How do I do it?

Thanks

RangeSum(above(sum({1< [Payment Group] = P([Payment Group]) >}[Payment Balance]),0,RowNo()))

Should be <= P([Payment Group])

[ogautier62]

Hi,

what are your dimensions ?

rowno() put to 0 at each change of dimension,

try to display rowno() to see if it could be that

(for my example your formula works)

regards

[k_burata]

Hi Olivier,

Yes it does work but I want to make it less than or equal to (<=) P([Payment Group]) instead of equal to (=).

Regards

[ogautier62]

ok,

so just use :

RangeSum(above(sum({1 }[Payment Balance]),0,RowNo()))

if your rows are sorted by Payment Group it will sum <=

[marcus_sommer]

I think it's not possible with p() but min/max might give you the desired view:

sum({1< [Payment Group] = {"<=$(=max([Payment Group]))"} >} [Payment Balance])

- Marcus