But I want summary of my formula which is going to be this
{dt_VU_GETMSG_SERVICE.TOTALAMOUNT_} % Sum ({dt_VU_GETMSG_SERVICE.TOTALAMOUNT_}, {dt_VU_GETMSG_SERVICE.FSERVICE_NETWORK})
What you have suggested will give me percentage of group footer field only.
I will explain you again ,I have one...
Yes {dt_VU_GETMSG_SERVICE.FSERVICE_NETWORK} is group footer.Yes It always show 100 based on my formula.But If I use simple formula it shows the last value
That formula you mentioned would only give me percentage based on my fields but how can I show summary on group footer?
This formula will show data on details tab.
{dt_VU_GETMSG_SERVICE.TOTALAMOUNT_} % Sum ({dt_VU_GETMSG_SERVICE.TOTALAMOUNT_}, {dt_VU_GETMSG_SERVICE.FSERVICE_NETWORK})
What will...
No I am not using the results on sub report.My main issue is I am not able to show the summary of percentage on group footer. I am able to show the percentage by simple formula as well the way you have mentioned but I need summary on group footer for that I have taken variables to show summary...
Footer shows the last value on details which in this case is 31 % and for original value I mean it is summing up the next value like first value is 20% and next value 9% but it shows 20+ 9 =29% and so on.
Another issue is --
I have one formula which shows the percentage according to gross we just calculated above. I used this formula to show percentage of gross.
shared numbervar rtTotal;
local numbervar thisTotal;
thisTotal :={dt_VU_GETMSG_SERVICE.TOTALAMOUNT_} % Sum...
I have one formula which shows the percentage according to gross we just calculated above. I used this formula to show percentage of gross.
shared numbervar rtTotal;
local numbervar thisTotal;
thisTotal :={dt_VU_GETMSG_SERVICE.TOTALAMOUNT_} % Sum ({dt_VU_GETMSG_SERVICE.TOTALAMOUNT_}...
okay It worked. I was using expert all the time after creating new though I am not an expert. I used editor and it worked. Thank you so much.I have 2-3 queries as well, so shall I create a new thread or ask in this one?
I used field explorer then created a new formula then under "Selection Formulas" > "Group Selection" I chose my sum fields and wrote this formula.
Sum ({dt_VU_GETMSG_SERVICE.TOTALAMOUNT_})-Sum ({dt_VU_GETMSG_SERVICE.AmountAfterSPShare_}) but it still says the result of selection formula must be...
I am trying to use this as suggested by some users.I dont know what to use a Instance1? Further I have only one group which is string network name.When I save this formula it says "Result of selection formula must be boolean". What should I do?
whileprintingrecords;
numbervar A;
numbervar B;
if...
Hi,
I have one group on my report which has two fields Gross and Net.On details I have their details and on the group footer I have their summary as sum of both gross and net and on the report footer again sum summary of gross and net.
Eg:
Details :
Name Gross Net
ABC 100 200
XYZ 200...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.