textboxformula

[Frank_Hartmann]

Hi QV Community,

I need to show up one value in a textbox but until now i´ve missed to configure the textboxformula in a proper way!

I have attached a qvw file.

anyone able to help?

thanks in advance

[rubenmarin · Accepted solution]

Hi Frank, try with:

=Sum(Aggr(

if(sum({$<MonthDiff={[$(vAktuellerMonat)]}>}Daten_Recherchen)>=$(vValue) and atan2(linest_m(aggr(sum({$<MonthDiff={'>=$(vZeitraum6Monate)<=$(vAktuellerMonat)'}>}Daten_Recherchen),AWS_Recherchen,MonthNumber),MonthNumber),1)/Pi()*180<>0  ,

    if(atan2(linest_m(aggr(sum({$<MonthDiff={'>=$(vZeitraum6Monate)<=$(vAktuellerMonat)'}>}Daten_Recherchen),AWS_Recherchen,MonthNumber),MonthNumber),1)/Pi()*180>atan2($(vGrenze),1)/Pi()*180,1,0),0), AWS_Recherchen))

[gautik92]

what is that value 12??

[Frank_Hartmann]

thank you soo much