Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think you need []
SUM({<Customer ={"=Count(DISTINCT [Bill #])=1"}>} [Invoice Amount])
=SUM({<custumer={"=Count(DISTINCT billno)=1"}>} value)
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
I think you need []
SUM({<Customer ={"=Count(DISTINCT [Bill #])=1"}>} [Invoice Amount])
Thank you so much it works well..
Realy Good
mark as correct the answer to that community get organized
I have marked it as Helpful. Didn't find any other option. Hope this is what was expected.
Thanks again
all correct!