Product Function

KrishnaElapavul — Mon, 19 Dec 2022 09:39:00 GMT

Hi
I have created filed "Integer type" at table level
I want to get the product of all lines in Hader level - created a field with "Integer type" at header level
I have written the formula at header level as PRODUCT(FT_10_ITEM_1), But i ma not getting the correct product value

I have tried for SUM(FT_10_ITEM_1) -- > IT worked correctly
Any suggestion please about product function?
FYI-- I have tired as parameter value also like PRODUCT(FT_10_ITEM_1:#) but still it is not working

------------------------------
Krishna Elapavuluri RPA Solution Lead
TEchnology Consultant
DXC.technology
Asia/Kolkata
------------------------------

RE: Product Function

Ben.Lyons1 — Mon, 19 Dec 2022 15:28:00 GMT

Hi Krishna,

You need two parameters to calculate a product e.g. PRODUCT(FT_10_ITEM_COUNT:#, FT_10_ITEM_COST:#). I don't believe there's a way to multiple all the values in a column by one another.

What are trying to achieve?

Thanks

------------------------------
Ben Lyons
Senior Product Specialist - Decipher
Blue Prism
UK based
------------------------------

topic RE: Product Function in Product Forum

Product Function

RE: Product Function