Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following formula that is not picking up the Financial Year Total results. I know its in the syntax but cant see it. where am I wrong please:-
Let vCurrentfYear = 2017;
If(Contact <> '', Count({'$Year={vCurrentfYear'} Type))
Cheers,
Laura
if you are using variable .. then in that case the value will change according to the selection.
I hope you have create the variable some thing like =Max(MonthYear)
Hi Laura,
Try this: Count({<Year={'$(vCurrentfYear)'},Contact -={""}>} Type)
HTH
Sushil
What Sushil shared, should work.
You can see this as well for better understanding?
Hi Sushil,
I am getting a red error under the first squiggle bracket:-
-={" "}>} Type))
thank-you!!!
It will be ok.. as this -= is not recognized by qv.
the only thing I don't like about the coding is the hard coded periods though
but it returns '0' in results
How about this
Aggr(Count({<Year={'$(vCurrentfYear)'}>} Type), -Contact)
Try with this one
If(not isnull(Contact),Count({<Year={'$(vCurrentfYear)'}>} Type))