topic Re: How to replace GL_CODE=50010 with sTOCK field ? in App Development

How to replace GL_CODE=50010 with sTOCK field ?

paulyeo11 — Fri, 13 May 2016 00:25:33 GMT

Hi All

My Table 1 expression work fine :-

Sum(Aggr(RangeSum(
Above(RangeSum(Above(Sum({<year, month , GL_CODE = {50010}>}[Amount]*1), 0, RowNo()))),
-Sum({<GL_CODE = {50010}>}TOTAL Aggr(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), YearMonth))), (YearMonth, (NUMERIC, DESCENDING))))
/Count(distinct YearMonth)

I have create a field sTOCK using load script :-

If([Reporting Code]>=50010 and [Reporting Code]<=50010,'sTOCK') as [sTOCK],

May i know how to convert the above expression using sTOCK instead of GL_CODE=50010 ?

Paul

Re: How to replace GL_CODE=50010 with sTOCK field ?

paulyeo11 — Fri, 13 May 2016 00:26:29 GMT

My QVF

Re: How to replace GL_CODE=50010 with sTOCK field ?

sunny_talwar — Fri, 13 May 2016 01:35:59 GMT

May be this:

Sum(Aggr(RangeSum(

Above(RangeSum(Above(Sum({<year, month, sTOCK = {'sTOCK'}>}[Amount]*1), 0, RowNo()))),

-Sum({<sTOCK = {'sTOCK'}>}TOTAL Aggr(Sum({<year, month, sTOCK = {'sTOCK'}>}[Amount]*1), YearMonth))), (YearMonth, (NUMERIC, DESCENDING))))

/Count(distinct YearMonth)

Re: How to replace GL_CODE=50010 with sTOCK field ?

paulyeo11 — Fri, 13 May 2016 01:55:10 GMT

Hi Sunny

Appreciate your help a lot.

Re: How to replace GL_CODE=50010 with sTOCK field ?

sunny_talwar — Fri, 13 May 2016 02:00:08 GMT

No problem Paul.

But I am not happy that you have been asking these easy things over the past few months. I would really like you to spend some time and learn simple set analysis. I see a lot of potential in you, but somehow when you keep asking these easy set analysis questions, I see lack of effort. Don't take me wrong my friend, I am more than happy to help you, but simultaneously, I would also like to see that you are able to grab from what you learn here and make improvements.

Finally, I don't want to discourage you from posting your questions here, so please continue to post whatever doesn't get resolved.

Best Regards,

Sunny

Re: How to replace GL_CODE=50010 with sTOCK field ?

paulyeo11 — Fri, 13 May 2016 02:11:47 GMT

Hi Sunny

Yes i will take your word very seriously and i will stop for a while and try to figure out before i move further.

Thank you for your patience with me. I am happy that you let me know this , as it is for my own goods.

Paul

Re: How to replace GL_CODE=50010 with sTOCK field ?

sunny_talwar — Fri, 13 May 2016 02:13:59 GMT

Great

And remember we are always here for you my friend

Best wishes,

Sunny

Re: How to replace GL_CODE=50010 with sTOCK field ?

paulyeo11 — Fri, 13 May 2016 02:39:16 GMT

Hi Sunny

Thank you very much. Once i have sucessful master SET , i think i owe you dinner when you happen to visit SG or i visit US.

Paul

Re: How to replace GL_CODE=50010 with sTOCK field ?

sunny_talwar — Fri, 13 May 2016 02:41:17 GMT

Sure thing

Re: How to replace GL_CODE=50010 with sTOCK field ?

paulyeo11 — Mon, 16 May 2016 07:09:22 GMT

Hi sunny

After i read the doc and i watch the few blog and also video. and i try to use the expression from you on below :-

For YTD sales expression :-

Sum(

{$<year = {$(=Max(year)-0)},

month = {"<=$(=Max({<year={$(=Max(year))},sales = {'*'}>} month))"}>}

sales)

Break down the above expression into 2 part :-

Select max year

{$<year = {$(=Max(year)-0)}

Select max month

month = {"<=$(=Max({<year={$(=Max(year))},sales = {'*'}>} month))"}>}

I further break in to very detail :-

and i look for below 3 component :-

$ = Identifiers

< > = Modifier

-0 or <5 = Operator

Sum

(

{

$<year =

{

$(=Max(year)-0)

}

month =

{

"<=$(=Max(

{

<year=

{

$(=Max(year)-0)

}

sales = {'*'}>} month))"

}

sales

)

and i try to add filter SOURCE={TDSPG} before > , i tested it work.

So i am already 30% success in SET. Thank you for your encouragement,

Paul

Re: How to replace GL_CODE=50010 with sTOCK field ?

sunny_talwar — Mon, 16 May 2016 10:04:24 GMT

Hey Paul -

I am glad my friend that you are making an effort. Let me know if I can be of any help in your learning process.

Best,

Sunny