Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression according to fields selected

I have to multiply a value according to the number of months selected:

Months selected: January and February

Amount_bgt: Amount * 2

The problem is that i have this amount compared in a table with another amount (real_amount), since the real_amount  has only data in February, the Amount_bgt gest multiplied only by 1.

Anyone can tell me how to fix this?

Thanks!

3 Replies
MayilVahanan

Hi

Use GetselectedCount(Month) and stored it as variable and then use it..

vSelectedCount = GetselectedCount(Month)

Then use like this

Sum(AMOUNT) * vSelectedCount

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Doesn't work...still appears the value as 1:

Month is Mes, as you can see i have 2 months selected

qv2.JPG

qv1.JPG

MayilVahanan

Hi

Can you able to post a sample file.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.