Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Script / calculate subtotal of Amount during process (item line in desing view) and display it at the bottom of masterpage before continue to the others pages

Profene_FR
Level 1
Level 1

Dear All ,

 

I'm facing an issue and I dont know how to do without use Script .
Unfortunatly, I don't know how to build a SCRIPT into the form .
Here the purpose of my request :

I have to display an invoice.
at the bottom of each Master Page

If invoice has only one page , I need to display a subform (S1) with several data as total amount, VAt .... etc !!!!
in case of several page, the previous subform ( S1 ) is replaced by S2 to display only one information.
this information is corresponding to the subtotal of Amount red into the Design View (Table-DATA -KWERT ) into the main area. .

One page or last page : display S1

Subform S1 bottom MP.png

Intermediate pages : Display Subtotal calculated: ( Sum of each Amount read in the current page) :

   Subform S2 bottom MP.png

I think I have to do at least , 2 things:
First : create a var ( SubT_Calculate) , calculating the Sum of amount during reading of data of each row .
Second : check if I'm in last page or not.

 

in this case ( not in last page)  :

-  have to hide S1 using a script  ,

-  get Var'value calculated and Display it in S2   .

 

If this possible ?

If possible ,  could you help to find solution to fix this issue, please ?

thank you so much for all help you could provide me.

best regards,

Take Care of you and your Familly .

Best regards,

Sebastien

 

 

7 Replies
Kosta_Prokopiu1
Employee
Employee

Hi, this looks like a rather complex form. I do not have the time to recreate a sample which comes close to yours just by looking here. If you send me a link to your form as a PM I can have a look at it and make suggestions.

Profene_FR
Level 1
Level 1

Hello @Kosta_Prokopiu1 ,

firstable , thank you about your answer. I'll try to extract the XMl in Adobe life cycle locally .

the reason is I can't send you a link cause the Form is created in SAP.

thank you again for your help.

Have a good day .

Best regards , Séb.

Kosta_Prokopiu1
Employee
Employee
Sum can be used for anything in dynamic subforms. If you have subformdyn with n instances and a field numericvalue in it then you can sum it with Sum(subformdyn[*].numericvalue). The path to the variable must be correct.
MatthewMa
Level 1
Level 1
I have the same problem but not that complicated. So do anyone know how to subtotal only one field value in subform? I only found sum which only used for table but I didn't found functions for subtotal a field in subform. If possible can anyone give me a simple sample for the function of subtotal? (I am just a poor business consultant who was trying to code in Adobe, so this request may seems **bleep**) Very appreciate. Thanks!
1TeamSKT
Level 1
Level 1

Tôi đang gặp 1 vẫn để lôi về sự kiện