Gallery Calculation in label

[dursunzeeee]

Hi ,

I could not do the Label 4 Calculation. Can you help me.

[dursunzeeee]

I find error ( *1)

If(ThisItem.Satis_Miktari*1 >= ThisItem._avg*1; "H"; "F") Now is working 

Thank you so much

[RandyHayes]

@dursunzeeee 

So then your Satis_Miktari column is NOT a numeric column?

[dursunzeeee]

When I apply a similar procedure to the other column, I still get an error

[RandyHayes]

@dursunzeeee 

You can't refer and do calculations on a label control.  You need to specify the Text property of the label.

When you use cost_label...this is a control.  When you use cost_avg_label.Text ...this is the text in the label.

Doing this *1 stuff is not a good practice.  It forces the conversion of the text to number - which is what you want, but this should be done with the Value function as it is reliable.  Doing *1 has a tendency to break when you play your app...especially if on other devices.

Also, you are trying to calculate on columns in your Gallery and then reference them inside the gallery...this is fine as long as you don't base your outer calculation on anything that is calculated inside the gallery that references what the outer calculation needs.  It is better practice to put this into your Items property - as we have done with _sum and _pop

You also need to consider the type of the columns you are dealing with in your data.  When we last left off, it appeared that the column that I thought was numeric was in fact text.  If it is text, then use the Value function on it.  If it is numeric, then there is nothing else needed.

So, for your Items property:

With({_items: Filter(Menu_Grup; Custom_Grup = Dropdown17_5.Selected.Result)}};
    AddColumns(
        AddColumns(_items;
            "_sum"; Sum(_items; Satis_Miktari);
            "_pop"; Average(_items; Satis_Miktari);
            "_cost"; Maliyet / Satis_Fiyati
        );
        "_costAvg"; Average(_cost)
    )
)

Your cost_avg_label Text property:

   First(Gallery3_4.AllItems)._costAvg

cost_label Text property:

    ThisItem._cost

costclass_label Text property:

     If(ThisItem._cost >= ThisItem._costAvg; "H"; "L")

[dursunzeeee]

Thank you all information and your patient.

Now i add but error again

[dursunzeeee]

I found my mistake.

But _costAvg and _cost give the same values.

_costAvg = average of values in columns

[RandyHayes · Accepted solution]

@dursunzeeee 

Sorry, I notice an issue with the last Items property I gave.  Should be this:

With({_data: Filter(Menu_Grup; Custom_Grup = Dropdown17_5.Selected.Result)};
    With({_innerData:
        AddColumns(_data;
            "_sum"; Sum(_data; Satis_Miktari);
            "_pop"; Average(_data; Satis_Miktari);
            "_cost"; Maliyet / Satis_Fiyati
        )
        };
        AddColumns(_innerData;
            "_costAvg"; Average(_innerData; _cost)
        )        
    )
)

We needed to actually do the last Average around the inner table.

[dursunzeeee]

Thank You So much now is working

[RandyHayes]

@dursunzeeee 

Very good!!

Hopefully you can implement the Header solution I provided in your other post as well.

[dursunzeeee]

i will try