Formula Query for Ranking
I'm creating competition between Agents by creating a leaderboard, however my formula query is giving me an issue. The ranking is based on the AFLAC Submitted Premium Last Week column, (FID 677). Ima...
Forum Discussion
I was able to resolve this with further self inflicted mental torture. If anyone is interested, the correct query is below. This formula did not need the "+ 1" after the Size(Get Records query that was shown in multiple resources.
var text SUBAFLAC =
"{677.GT." & [AFLAC Submitted Premium Last Week] & "}" &
"AND{23.EX.1}" &
"AND{691.GT.0}";
Size(GetRecords($SUBAFLAC))