if condition with set analysis

jalpashukla — Tue, 13 Sep 2022 07:27:45 GMT

Hello everyone.. I'm working on an application which runs on some conditions as below:

Project_Status: 'Active'

at_feedback_rating_id <> 0

MaxCsatDate = at_csat_received_date (where MaxCsatDate is max(at_csat_received_date ))

project id <> 0

1) if the above conditions dont match, the result would be '0.00% from 0 projects'

2) if the above conditions do match, the average of rating and count of projects ids should also fulfilled the mentioned conditions while calculating KPI.

--------------------------------------------------------------------------------------------------------------------------------------------

Error I'm facing with this KPI syntax:

if(GetPossibleCount (at_projectid) =0 , '0.00% from 0 Projects',
repeat(chr(160),6) & if(GetPossibleCount(at_feedback_rating_id) = 0,'0.00%',
Num((Avg (If([project_status]= 'Active' and MaxCsatDate = at_csat_received_date, at_feedback_rating_id))/
max({1} total at_feedback_rating_id)) , '#0.00%')) & ' from ' &
count({<[project_status]= {'Active'},at_feedback_rating_id = {">0"}, MatchDate = {1} >} distinct at_projectid)
& ' Projects' & repeat(chr(160),6))

topic if condition with set analysis in App Development

if condition with set analysis