Need help with SET ANALYSIS statement

[#1]

I have three prices for each item that we sell:

Billed Price, Entitlement Price, List Price

for each: labor and material

Entitlement Price is the only selection which may be NULL

I have the pdf  by Mackay on Set analysis, but it also assumes just a touch more knowledge than I have,

after one week. . . but I can't figure out from reading it, how to select a set with one parameter equal to

and the second parameter not null or greater than zero

any suggestions?

sum({$<Labor={'Y'},IsNum(Entitlement_Rate)>} Billed)

thank you in advance. .

TL

[MayilVahanan · Accepted solution]

Hi

Try like this

sum({<Labor={'Y'},Entitlement_Rate = {">0"}>} Billed) //greater than zero

sum({<Labor={'Y'},Entitlement_Rate = {"*"}>} Billed) //get not null value

[#3]

Mayil Vahanan Ramasamy

Thanks Mayil Vahanan Ramasamy - works like a champ!