sum and left

[Tommmy]

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)

[Mark_Little]

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)

[martinpohl]

Hi,

the Flag suggest is the better, but you also can do this with set expression

sum({<Account-={"1*"}>} amount)

Regards

[BrunPierre]

This maybe

Sum({<"=Left([Account],1)"-={'1'}>}amount)