How to get the percentage value in the back end Not in front end

[Anonymous]

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.

[Lisa_P]

Please attach file