You’re offline. This is a read only version of the page.
53
I have created the table below Table A, which works ok. I need a template table that displays the Item & CatStatus columns as shown in Table B1 with a CountValue of 0, when the Collection/Table is Empty.
Code:
ClearCollect(
ECountInvCat,
AddColumns(gvInvTable, "CatStatus",
Switch(Status, "Approved","Complete", "Rejected: Amount Exceeded","Critical", "Awt Approval", "Pending"))
);
ClearCollect(
ECountInv,
AddColumns(
GroupBy(ECountInvCat, "CatStatus","InvItems"),
"CountValue",CountRows(InvItems),
"Item","Invoice"
)
);
ClearCollect(
ECountPOCat,
AddColumns(gvPOTable, "CatStatus",
Switch(Status, "Progress Ongoing","Pending", "Complete","Complete", "Deferred", "Critical", "Pending"))
);
With(
{
outputTable: Ungroup(
Table(
{tableObject: ECountInv},
{tableObject: ECountPro}
),
"tableObject"
)
},
ShowColumns(
GroupBy(
outputTable,
"CountValue",
"Item",
"CatStatus",
"Grouped"
),
"CountValue",
"Item",
"CatStatus",
"Grouped"
)
)
Table A
Table B1
Share
Report
All responses (
Answers (
