This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Sum Expression not summarizing Price as expected

Posted on 08-27-2020 12:34 PM
Daisy_Ramirez
Silver 5
Silver 5
Reply posted on --/--/---- --:-- AM

I have a sum statement that doesn’t seem to be calculating as expected.

We have a quotes and commission table. There could be multiple records in the commission table for a single quote.

To sum the commission for each quote, I have a virtual field in the quotes table (vir_commission_act_pay) and display it on an email for the sales reps but it seems to be grabbing the last of the 2 records in this case vs. providing the Sum of the 2 records.

3X_c_4_c4c9022775bd2ab2733a4c288a1444c447a8aa27.png

Records in Commissions table

3X_1_d_1de7207ee2d90855477db2de9f3d34319d35d452.png

Email Report field
3X_c_a_cace8b10e6bcac3ee4483db86a77f99fa7c0a706.png

0 3 149
Topic Labels
0 Likes
3 REPLIES 3
Top Labels in this Space