Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm writing set analysis for total charges where charge id is not null.
Sum({<[Charge ID]-={"' '"}, REVENUE_DATE={"<= $([REPORT DATE]) "}>} TOTAL_CHARGE_AMT)
but it doesn't seems to work . it gives me same result as sum(TOTAL_CHARGE_AMT). which is not right .
Any help is highly appreciated.
keep up the Good work Sunny. I really appreciate all your help and I guess so does rest of qliker's.