My SET expression refuse to display 1st row of my data ?

[paulyeo11]

Hi All

I have a data structure , which have a field name = ACC_NAME , when i select this 1. REVENUE , from the list box i confirm i have value , and from field name = Reporting Code , it shown

00001 highlighted.

when i create a Table , My expression is sum(Amount) , it does display 1 REVENUE amount on Table (1).

But when my expression change to SET as below :-

(

money(

if([Exec P&L Level] = 's','',

sum({$<year = {$(=max(year)-0)}

, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} Amount)/1000

)

, $(vCurrencyFormatK))

)

May i know , how to make the 1 REVENUE appear when using above SET expression ?

Paul

[lironbaram · Accepted solution]

hi the 1 Revenue isn't displayed because of the if stement yout set analysis is ok

it's actually quite simple 1 Revenue has 's' as the value in [Exec P&L Level] this is why it's not displayed

[paulyeo11]

Hi liron

It took me quite a while to figure out the expression cause the problem. Once I remove it . It work fine. Thank.

You must be very good in script. As now I still not understand why ?