Calculation of sum of values Picking up String

[AH]

I have a table with a field of InvoiceID, value begins with CR and DB and i have to sum the LineAmount picking only the value start with CR.

How do i do that? Is there any clue about that?

Please suggest.

Thanks,
Shan

[its_anandrjs · Accepted solution]

Hi,

Try expression

=Sum( if( Left(InvoiceID,2) = 'CR' , LineAmount))

Regards

Anand

[AH]

Hi Anand,

Thanks for the quick response. I got the exact answer.

I really appreciate it!

Thanks,

Shan

[its_anandrjs]

Hi,

Thanks, Close the thread by selection appropriate answer Correct or helpful.

Regards

Aannd