Text object: formula

[Anonymous]

Hi,

I was trying to create  a text object in order to show complaints for 2016 and by phone.

to do that in text i write this:

=Num(count({<DateReceivedYear={"2016"} and SubmittedViaName={"Phone"}>}ComplaintId), '#,##0', '.' , ',' )

but it turns out an error.

If I only write one condiction it works but as this case is of two conditions it does not works (I don't know if the ommand "and" is right etc)

Could you help me please?

Thanks

[Digvijay_Singh]

try this -

=Num(count({<DateReceivedYear={2016},SubmittedViaName={"Phone"}>}ComplaintId), '#,##0', '.' , ',' )

[Digvijay_Singh · Accepted solution]

Use single quote for literals -

=Num(count({<DateReceivedYear={2016},SubmittedViaName={'Phone'}>}ComplaintId), '#,##0', '.' , ',' )

[Anonymous]

Perfect,

You are a master!!

Thanks a lot