Hello Experts.
Please can anyone help on this.
Iam attached a file.
(RangeSum(CD,HA,HB,OVSD)/Distance)*1000 as Score,
IF((RangeSum(CD,HA,HB,OVSD)/Distance)*1000<=20,'Green', IF((RangeSum(CD,HA,HB,OVSD)/Distance)*1000>20 and (RangeSum(CD,HA,HB,OVSD)/Distance)*1000 <=50, 'Yellow',
IF((RangeSum(CD,HA,HB,OVSD)/Distance)*1000>50, 'Red'))) as Category ;
And I am using the expression about find the value of Green percentage in the FRONTEND using set analysis
=Round((sum({<Datums={"$(=Max(Datums))"},Category={'Green'}>} Distance) / Sum({<Datums={"$(=Max(Datums))"},Category={'Green'}+{'Yellow'}+{'Red'}>} Distance))*100,0.01) &' %'
But i want the find the value in the BACKEND.
