set analysis with isnull function

[khanashique]

Hi,

I am struggling  with the expression below, individual expression works fine, but when i join them with isnull function is does not return any result...

if(isnull(Year) and isnull(Month), 
Sum({<Line = {'Printing'},Year = {"$(=Year(today()))"},Date ={"=Month(today())=Month(Date)"}>}Planned_Qty)
,Sum({<Line = {'Printing'},Year = {"$(=getfieldselections(Year))"},Month = {"$(=getfieldselections(Month))"}>}Planned_Qty))

Need your kind expertise...

Thanks.

[anushree1]

Please check whether the "IF" condition is being satisfied by taking the if condition alone on a Text box , there could be chances of either of the field not being NULL or maybe its not null but space so you could also try using isnull(trim(<<fieldname>>)) in your "IF " condition.

[Seyko]

Hello,

Replace IsNull by a Len ( IF( Len(Year)=0 and Len (Month)=0 ....)) and see if it works.

cordially.

[sunny_talwar]

Why don't you try this?

If(IsNull(Year) and IsNull(Month), 
Sum({<Line = {'Printing'}, Year = {"$(=Year(Today()))"}, Date = {"=Month(Today()) = Month(Date)"}>} Planned_Qty),
Sum({<Line = {'Printing'}>} Planned_Qty)
)

[khanashique]

Thanks Sunny for your reply,

The expression you gave i have tried earlier, it does not return the result for first part of expression it returns only second part of the expression and i.e. whole data.

thanks once again.

[khanashique]

hi thanks,

i have applied len (if, it returns zero as value...

regards.

[sunny_talwar]

I guess I am not sure the context of the use of your expression. From what I understood, you want to show the second expression when Year and Month are not selected. Is this not true?

[khanashique]

Hi,

I wanted to show the data for first expression (for current month), when year and month is null.

Thanks...

[sunny_talwar]

and you have used year and month as dimension?

[sunny_talwar]

Also, if year and month are null... then what does this even mean?

um({<Line = {'Printing'}, Year = {"$(=Year(Today()))"}, Date = {"=Month(Today()) = Month(Date)"}>} Planned_Qty)

Year and Month are Null... why do you expect to see Year = Year(Today()) when it is null? I think you would need to provide a sample to show what you have and provide information of what you are hoping to get