Query Regarding SUM()

[tsg_despatch]

Please explain how to Sum “Total Payable” Selected Field as per image provided.

[Chris_Jeal]

Hi @tsg_despatch,

Would that not be something like;

Sum(
Select(
PAYMENT DUE REPORT[Total Payable],
[Checkbox column],TRUE
))

[tsg_despatch]

@Chris_Jeal This is not working, My purpose to total the Checked DC No field & Total “Total Payable” Field and store the Total in another table

[Aleksi]

If you want to see the sum of those four selected records in that view, I’m afraid that’s not possible at this moment.

[tsg_despatch]

@Aleksi I don’t want to see the Total Amount, However I want to make workflow and send an email to our vendor regarding total payment made to him with mention of “DC No”. Refer to screenshot.

[Steve]

You said this:

tsg_despatch:

I don’t want to see the Total Amount

Having previously said this:

tsg_despatch:

Please explain how to Sum “Total Payable” Selected Field

“Sum Total Payable” and “Total Amount” certainly seem to be the same thing to me.

tsg_despatch:

However I want to make workflow and send an email to our vendor regarding total payment made to him with mention of “DC No”. Refer to screenshot.

Your screenshot shows nothing of a workflow, an email, or “mention of ‘DC No’.” This is the first you’ve mentioned it.

tsg_despatch:

This is not working,

Because @Chris_Jeal addressed the question you asked rather than the one you apparently want answered.

tsg_despatch:

My purpose to total the Checked DC No field & Total “Total Payable” Field and store the Total in another table

You didn’t say that. In fact, this is even different than what you told @Aleksi.

Please restate your question and include all of your requirements so that we don’t waste our time.

[tsg_despatch]

@Aleksi In simple words, I want to total checked fields and sane the total in another table.