Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use single quote for literals -
=Num(count({<DateReceivedYear={2016},SubmittedViaName={'Phone'}>}ComplaintId), '#,##0', '.' , ',' )
try this -
=Num(count({<DateReceivedYear={2016},SubmittedViaName={"Phone"}>}ComplaintId), '#,##0', '.' , ',' )
Use single quote for literals -
=Num(count({<DateReceivedYear={2016},SubmittedViaName={'Phone'}>}ComplaintId), '#,##0', '.' , ',' )
Perfect,
You are a master!!
Thanks a lot