Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have below expression from sunny working fine . May i know how to break the below expression into 2 part ?
(RangeSum(Above(RangeSum
(Above(
Sum
(
{
<
year, month, aP={aP}
>
}
[Amount]*-1), 0, RowNo()))),
-
Sum(
{
<
aP={aP}>
}
TOTAL Aggr(Sum(
{
<
year, month, aP={aP}
>
}
[Amount]*-1), YearMonth
))))
So that i can make it as load script.
Paul
my qvw
Above, Aggr() and set expressions do not work in the load script, so it is not a simple conversion. And its not clear how you want to "split" the expression. You also need to explain the context of the expression - if its in a table/chart, what are the dimensions, and how are they sorted, etc.
Hi Jona
The reason I want to spilt is because I need to compute the Cash conversion cycle. I manage to get 2 items right but only 1 items I cannot get it correct. That AP account payable.
Are you able to give me some suggestion ?
Paul
Sent from my iPhone