Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Dear All,
Thank a lot for your replies, the requester told, that he doesn't need this thing anymore
Have a nice day
That's good to hear, Finally You convinced the Client ..