Help

[nagarjuna_kotha]

HI I have an issue,

I attached one file to u.

In the i ahve one value in Text box,On the above i have one list box.If i select Hendred the should come in hundreds,if i select thousand ,the value should come in thousand.likewise.

Regards,

nagarjuna

[pokassov]

Hello!

Your text box is calculating sum(Sales).

Taking in mind that field "Sales" lies in the table "Data 2", which doesn't have any link with table Data where I see field ID, the behaviour is normal.

[maxgro]

=if(GetPossibleCount(ID)=1, Sum(Sales) / Val, sum(Sales))

[miguelbraga]

Hi

Please, refer to the attached QVW file. Hope you understand what I've done.

Miguel

Notes: Your Listbox need to be selected with Always One Selected to force only one option. Se the IF condition to know how I've done it in the TexBox!

[NareshGuntur]

Hi Nagarjuna,

Please use the below expression in text object and let me know if this is what you are expecting.

=Sum(Sales)/Only(Val)

Cheers,

Naresh

[sudeepkm]

Braga's solution would work very well. Just one thing to indicate that instead of if else you can simply use.

=sum(Sales)/Val

As he suggested you need to use Always one selected value so that there will always be a value in the denominator.