Jump to content

Calculation pulling from portal rows


amypaulsmom
 Share

This topic is 7175 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Good morning - here i go again smile.gif

On my invoice screen - I have a portal set up to enter my items being purchased. The commission amount is calculated from the information in the portal rows.

My delimna is - if I have them enter a FIN(Finance Charge) or ADJ (Adjustment) in the Item Code box of the portal - I do not want this line item to be included in the Comission Calculation.

I have the Commission Calulation set up - If(lineitem:item code ="FIN" and "ADJ", 0, SUM(lineitem:item cost).

This seems to work for the first line of the portal. But typically - the FIN or ADJ item code is entered farther down the portal entry. How can I have my Commission Calculation look through all the portal records?

I hope this makes sense and look forward to your advice.

Link to comment
Share on other sites

This is what you said.

"Define a calc field in Line Items that include only the elements you want to have counted in the aggregated total. THen in the parent file, use the aggregate function SUM to calculate that total."

I may not be thinking this morning - but that doesn't make sense.

I hear you saying to do calculation in the line items and have it "find" the Item Codes I want. There are only 3 Item Codes I do not want to include and many that I do. Would you please write an example as to what you are suggesting.

Thanks

Link to comment
Share on other sites

This topic is 7175 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.