Answered

Sum function will not return result when column name contains ''

(0) Share

Report

Posted on by JMGCORNATOR

Hi there,

I am having trouble getting my sum calculations to appear in a label and im starting to get annoyed 🙂
I have established connection to a SQL-database which contains data from NAV and the connection works just fine.

One of the screens of my app contains three labels: "Total quantity", "quantity invoiced" and "quantity to ship" as shown below. Dont mind the datatable in the screen.

Anmærkning 2019-10-24 112407.png

These labels should contain the total sum of a column found i my SQL-database. For the "Total Quantity" there is no problem at all when i use the below code. Except that it will not show "psc".

Sum(
 Filter(
 '[dbo].[CRONUS TRIMIT W1 Ltd_$Sales Line]';
 'Document No_' = LblAppName6.Text
 );
 Quantity
) & " psc"

However, when i use the exact same code for "quantity to ship" and "quantity to invoice" i can see powerapps reacting shortly but the sum does not appear. There is no error-message and the database columns are not empty.

Sum(
 Filter('[dbo].[CRONUS TRIMIT W1 Ltd_$Sales Line]';
 'Document No_'=LblAppName6.Text
 );
 'Quantity Invoiced'
)

Seems to me that when the expression in Sum() contains more than one word, something goes wrong?

thx

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @JMGCORNATOR

What is the datatype for 'Quantity Invoiced' column?

Can you try to update your expressions as:

For Quantity:

Concatenate(Sum(
    Filter(
        '[dbo].[CRONUS TRIMIT W1 Ltd_$Sales Line]';
        'Document No_' = LblAppName6.Text
    );
    Quantity
);" psc")

For Quantity Invoiced:

Sum(
    Filter('[dbo].[CRONUS TRIMIT W1 Ltd_$Sales Line]';
            'Document No_'=LblAppName6.Text
    );
Value('Quantity Invoiced')
)

Hope this helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
JMGCORNATOR 50 on at

Like (0)

Report

@yashag2255

The concatenate() does not change much for me, however, I managed to get past the problems with Quantity.

For the Quantity Invoiced, everything works fine now 🙂 I kind of messed up - The column does contains values, but they are all zero, so i thought a value of zero would appear when summing.

Anyways, Thank you!

Was this reply helpful? Yes No