Hi all.
I got DSO with procent keyy figure (Z_PRCNT).
I need do summarize the key figure in transformation if I'm getting it with the same key, BUT if Z_PRCNT is already = 100 or i'm geeting above 100 on summation, I need to post exact 100 as result.
Example as illustration
data source:
KEY______PROCENTS
011______30
011______80
012______10
012______20
013______150
must get results in DSO as
ZKEY______Z_PRCNT
011______100
012______30
013______100
thanx in advance