topic Re: Division gives wrong results in load editor in App Development

Division gives wrong results in load editor

Milaf — Tue, 21 Nov 2023 06:47:09 GMT

Hello, I would like to ask for your support for an operation that I can calculate in the frontend but not in the load editor.

Step1:
...

Sum(Acil_Hesap2) as Acil_Hesap2,
Sum(Normal_Hesap2) as Normal_Hesap2 ,
Sum(Toplam_Hesap2) as Toplam_Hesap2,
sum(Acil_Adet2) as Acil_Adet,
sum(Normal_Adet2) as Normal_Adet,
sum(Toplam_Adet2) as Toplam_Adet

...

Step2: (division returns an incorrect result in this step)

...

sum(Acil_Hesap2)+ sum(Acil_Adet) as AcilOran,
sum(Normal_Hesap2)+ sum(Normal_Adet) as NormalOran,
sum(Toplam_Hesap2)+sum(Toplam_Adet)as ToplamOran

...

In fact, the process I want to go to is working on the master item on the front side, but I cannot call the master item to calculate the variable. So I tried to calculate it in the load editor, but it does not work like on the front side.

The calculation I wanted in the final:
(SUM(AcilOran) + sum(NormalOran) +sum(ToplamOran))/3 as TotalDegisim

I hope someone can help me with what I can't see.

Thank you.

Re: Division gives wrong results in load editor

Lisa_P — Tue, 28 Nov 2023 04:50:45 GMT

Aggregations (like sum) can only be used in the load script in conjunction with the Group by function to aggregate values by a dimension or multiple dimensions.

Re: Division gives wrong results in load editor

Parthiban — Tue, 28 Nov 2023 05:28:04 GMT

Try to take resident of step 1
like

Table1:

load
Sum(Acil_Hesap2) as Acil_Hesap2,
Sum(Normal_Hesap2) as Normal_Hesap2 ,
Sum(Toplam_Hesap2) as Toplam_Hesap2,
sum(Acil_Adet2) as Acil_Adet,
sum(Normal_Adet2) as Normal_Adet,
sum(Toplam_Adet2) as Toplam_Adet
from path...

Table2:

load

((Acil_Hesap2+Acil_Adet2)+(Normal_Hesap2+Normal_Adet)
+(Toplam_Hesap2+Toplam_Adet))/3 as Final_Result

resident Table1;

Just try this suppose this will not work we will try any other method..