Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
I need the sum of amount over all account not starting with '1' as first value. The following formula doesn't work, there is a syntax problem. Any ideas? Thanks.
sum({<left([Account], 1)-={'1'}>} amount)
I would move you left(Account,1) to script and then reference in the set analysis.
So
left(Account,1) as Account_Flag
sum({<Account_Flag -={'1'}>} amount)
Hi,
the Flag suggest is the better, but you also can do this with set expression
sum({<Account-={"1*"}>} amount)
Regards
This maybe
Sum({<"=Left([Account],1)"-={'1'}>}amount)