Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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..