Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Developers
I have a expression like
=sum(goal_Reported_Out) - count({<count_id={' '},Bill_Type_Details-=>}DISTINCT Reported_Out_case_id)
How can i calculate avg of this expression. i tried but its giving error.
Can someone help me please?
Thanks
Anil
Did you use Avg(Aggr(.....)) when you tried? I think you need to provide some input data for us to show what you are trying to do. Just by looking at the expression, we all will have a hard time providing the correct answer.
Thanks for the reply bro.
I tried avg but its giving error. Can we create the below exp as a field in backend? The fields are from same table. if yes how to write this field in back end so that in the calculation i can do avg(sum(goals)- created field ) is it possible?
count({<count_id={' '},Bill_Type_Details-=>}DISTINCT Reported_Out_case_id)
Thanks
Anil
We might achieve one way is this
IF count_id = IsNull(count_id) and Bill_Type_Details <> '*'
THEN
LOAD DISTINCT
Field1,
Field2 .... From Table;
ElseIf
Load Field1, Field2 .. FROM Table;