Logic Help1

[abhaysingh]

Hi Guys,

Pls find the sample file and desired output in it, Pls suggest , totally stuck

[Kushal_Chawda]

What is expected output in excel? I am not able to open QVW

[abhaysingh]

Desired Output = if i select any date than that particular raw shud come and rest where date is blank shud come.

thanks

[t_chetirbok]

Hello!

if I understand your requirement, try to use this expression: sum({$+1<LinkDate={"-"}>}Qty)

[Chanty4u]

chk dis

[Kushal_Chawda]

try below expression

=sum({<LinkDate ={"$(=max(Date))"}> + <LinkDate-={"*"}> } Qty)

[sunny_talwar]

May be this:

Sum({$+<LinkDate = {'-'}>}Qty)

[abhaysingh]

Small Correction in the Data, LinkDate does not contain "-" in the Data.

So if i do not have "-" in the Data than what shud be the logic?

[sunny_talwar]

If it is truely null, then this:

Sum({$+<LinkDate = {"=Len(Trim(Only({<LinkDate>}LinkDate))) = 0"}>} Qty)

[t_chetirbok]

So, if your field LinkDate is null, you can try this expression:

sum({$}Qty)

+sum({1} if(isnull(LinkDate),Qty))