Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Pls find the sample file and desired output in it, Pls suggest , totally stuck
What is expected output in excel? I am not able to open QVW
Desired Output = if i select any date than that particular raw shud come and rest where date is blank shud come.
thanks
Hello!
if I understand your requirement, try to use this expression: sum({$+1<LinkDate={"-"}>}Qty)
chk dis
try below expression
=sum({<LinkDate ={"$(=max(Date))"}> + <LinkDate-={"*"}> } Qty)
May be this:
Sum({$+<LinkDate = {'-'}>}Qty)
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?
If it is truely null, then this:
Sum({$+<LinkDate = {"=Len(Trim(Only({<LinkDate>}LinkDate))) = 0"}>} Qty)
So, if your field LinkDate is null, you can try this expression:
sum({$}Qty)
+sum({1} if(isnull(LinkDate),Qty))