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.

[miskinmaz · Accepted solution]

Hi,

If your expression consider the Max Datums based on user selection , then it is not possible to create the expression in backend. Also can you explain why do you want it at backend.

[Anonymous]

Thanks Miskin Mazgaonkar.

Because I want find the value in the BACK END without using set analysis in the front end.