Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mohsinhasan87

    Sum of percentage on group footer

    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...
  2. mohsinhasan87

    Sum of percentage on group footer

    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
  3. mohsinhasan87

    Sum of percentage on group footer

    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...
  4. mohsinhasan87

    Subtract (sum fields) which are on report footer

    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...
  5. mohsinhasan87

    Sum of percentage on group footer

    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.
  6. mohsinhasan87

    Sum of percentage on group footer

    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...
  7. mohsinhasan87

    Subtract (sum fields) which are on report footer

    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_}...
  8. mohsinhasan87

    Subtract (sum fields) which are on report footer

    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?
  9. mohsinhasan87

    Subtract (sum fields) which are on report footer

    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...
  10. mohsinhasan87

    Subtract (sum fields) which are on report footer

    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...
  11. mohsinhasan87

    Subtract (sum fields) which are on report footer

    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...

Part and Inventory Search

Back
Top