Expression help

[#1]

Hi I have expression below, i want to deduct 100 from that.

100 - expresion. The resulst should be 2 decimals with percentage.

=num(TextCount({<Month = {'$(vMonth)'}, Year = {'$(vYear)'}>}Topic) / count(count1) , '#.00 %')

[ajaykumar1]

Hi ,

Try like;

=100-(num(TextCount({<Month = {'$(vMonth)'}, Year = {'$(vYear)'}>}Topic) / count(count1) , '#.00 %'))

Regards,

Ajay

[#3]

Hi Ajay,

I already tried. forgot to mention - The resulst should be 2 decimals with percentage.

[ajaykumar1]

Hi,

Above expression not worked?

For 2 decimals Go to your table---Right click properties---Number---select your expression in left side---Fixed to 2

and select the show in percentage check box.

Regards,

Ajay

[#5]

Hi,

Unfortunately I am using Textbox.

[#6]

Any one help?

[ajaykumar1]

Hi,

Can you tell me how you created the TEXT Box.Am new to text box.

Thanks,

Ajay

[PrashantSangle · Accepted solution]

Hi,

Then Try,

=Num(100-(num(TextCount({<Month = {'$(vMonth)'}, Year = {'$(vYear)'}>}Topic) / count(count1) , '#.00')) ,'#.00 %')

Regards

[#9]

This should do the trick:

=num(100-(TextCount({<Month = {'$(vMonth)'}, Year = {'$(vYear)'}>}Topic) / count(count1) , '#.00 %'))