Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Fried,
How to Write in set analysis for bellow Expression. Pls Help me on it.
=Sum(if([LinkDate] <= vMaxDt
and (Len([C_Date]) <=0
or
[C_Date] > vMaxDt) and ([Y/N Flag]='N') ,[Amount]))
Thanks,
vind
Hi,
I would try sth like:
sum({< {set1}*{set2}} + {{set3} *{set4}}>}, Amount)
where
set1= LinkDate ={"<=$(vmaxDt)"}
set2= C_Date ={""}
set 3 = C_Date={">$(vMaxDt)"}
set4 = [Y/N Flag] = {"N"}
Fabrice
sum({<[LinkDate]<={'vMaxDt'},[Y/N Flag]={'N'},[C_Date]={'>=$(vMaxDt) <=0'}>} [Amount])
thanks for reply, but it is C_Date is need with Len function.
Hi Aunez,
C-Date field is required with Len Function
Try like:
Sum({<[LinkDate]={"<=$(=vMaxDt)"}> * <[C-Date]={"=Len([C-Date])<=0"}> + <[C_Date]={">$(=vMaxDt)"}>
* <[Y/N Flag]={'N'}>}[Amount])
OR,
Sum({ ( <[LinkDate]={"<=$(=vMaxDt)"}> * <[C-Date]={"=Len([C-Date])<=0"}> ) + (<[C_Date]={">$(=vMaxDt)"}>
* <[Y/N Flag]={'N'}> ) }[Amount])
// depending upon your OR, AND combination logic second option should work if not the first one.
Thanks for reply, above two expressions are not working friend
There could other issues like date format; variable expansion. It would be easier to understand and help that if you could upload a sample app.
No, That Expression Going Success, but need this in Set Analysis.