How to account the sum when the id is not digital such as A001?

[#1]

Hi,All. I hava a question about  How to account the sum when the id is not digital such as A001? Thanks!

[jagan]

Hi,

To solve this easily we need to get the addition flag field in script like below

LOAD

*,

If(IsNum(AccountNum), 0, 1) AS NonDigitAccount

FROM DataSource;

Now in expression you can directly use the below expression

=Sum({<NonDigitAccount={1}>} MeasureName)

If you don't want to change the script then you can try below expression

=Sum(Aggr(If(Not IsNum(AccountNum), MeasureName), AccountNum))  // The performance of this expression is not better when compared to the previous one.

** Note: Replace AccountNum and MeasureName with your actual field names.

Hope this helps you.

Regards,

Jagan.