cancel
Showing results for 
Search instead for 
Did you mean: 

Product Function

KrishnaElapavul
Level 6
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
------------------------------
1 REPLY 1

BenLyons
Staff
Staff
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
------------------------------
Ben Lyons Senior Product Specialist - Decipher SS&C Blue Prism UK based