Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have 2 Table :-
Table 1 Expression :-
If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=91'} >}total_ar * 1) > 0,
Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=91'} >}total_ar * 1))
Table 2 Expression :-
If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=91'} >}total_ar * 1) > 0,
Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=91'} >}total_ar * 1))
May i know how to combine both table into 1 Table. and user just need to click on the button >90 Day or > 120 day ?
Now i manage this issue by 2 sheet.
Paul Yeo
Hi Krish
Many thank for your sharing.
I have try but it does not work.
Hope you can point to me where i go wrong ?
Paul Yeo
Hi Krish
Hi Sir
I manage to figure out , and now it is working fine in table 1.
I now need to modify the expression to compute >90 day and less then 120 day.
I expect the result of the table should display 5304 and 687.
If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=$(=vDay)''<=$(=vDay1')} >}total_ar * 1) > 0,
Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=$(=vDay)''<=$(=vDay1)'} >}total_ar * 1))
I have try the above expression , but it does not return any value.
Paul
Hi Krish
I post one more similar issue , can you help to take a look ?
Create var vYn1 and replace 8 with $(vYn1) not working ?
Paul