Writing syntax

[#1]

Can you please help me write a set analysis expression for the following problem.

Table contains fields : Bill no. , Customer name and invoice amount

I would like to query the total invoiced amount for customers who have only one invoice against their name.

thank you

[#2]

=SUM({<custumer={"=Count(DISTINCT billno)=1"}>} value)

[#3]

Thank you so much for your prompt reply.

i used the following as these are the exact field names

SUM({<Customer ={"=Count(DISTINCT Bill #)=1"}>} Invoice Amount)

but it says error in expression

[#4 · Accepted solution]

I think you need []

SUM({<Customer ={"=Count(DISTINCT [Bill #])=1"}>} [Invoice Amount])

[#5]

Thank you so much it works well..

[#6]

Realy Good

[#7]

mark as correct the answer to that community get organized

[#8]

I have marked it as Helpful. Didn't find any other option. Hope this is what was expected.

Thanks again

[#9]

all correct!