Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends,
Please help me in evaluating below expression
count(Distinct {<
[Sell_status] = {'Available'},
CreateDate = {'@(=max(date(CreateDate)))'},
Dispatched ={@(vflag)}
>}[sellid])
Need to understand purpose of '@'
Thanks in advance
Are you getting values using "@"
Have check that the Syntax is showing correct at top in Expression tab like it shows Expression is OK?
Expression default shows Ok because we are calling with in the Single and/or double quotes. In fact, I never used this. My Boss stalwar1 may know this..
Here not used in single quotes-
Dispatched ={@(vflag)}
so this will show an error.
I tried same expression and it is showing syntax error.
Is this expression defined in the script by any chance?
I am your friend Anil
count(Distinct {<
[Sell_status] = {'Available'},
CreateDate = {'@(=max(date(CreateDate)))'},
Dispatched ={@(vflag)}
>}[sellid])
in this case it gives distinct count for sell_status is available...it ignores createdate and dispatched...as they don't exist