How to take values from one column to another

[ivanaksen]

Hello dear all,

I have a tough question, which trying to resolve third day:

So, I have massive of data, but it`s necessary to make some changes

It`s necessary to have: If there are values with "-" at the beginning, they should have the same Aging as the next value without "-" at the beginning. So I have bellow formulas in visualisation:

Aging is taking from script;

Current is Sum({<[Aging] = {"<89"}>} [Amount.Loc]);

Aged over is Sum({<[Aging] = {">89<179"}>} [Amount.Loc]);

Total is sum([Amount.Loc])

So the main aim is to have sum of money with "-" at the same column as the next positive sum.

Thanks in advance

[ivanaksen]

Dear All,

Thank a lot for your replies, the requester told, that he doesn't need this thing anymore

Have a nice day

[balabhaskarqlik]

That's good to hear, Finally You convinced the Client ..