Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have table containing below columns.. (FYI... Orders recevied from our customers sent for execution to our supplier, we are working as an intermediate)
Customer Name
Customer ID
Customer Order Number
Customer Part Number
Order Quantity
Order Price
Supplier ID
Supplier Part Number
Supplier Price
I want final table with Customer Order Total (=Order Quantity * Order Price) after Order Price column and Supplier Order Total (=Order Quantity * Supplier Price) as a last column.
Please help....!!!
Hi,
You need to set its decimal place by change the setting of this column. Just go to Properties->Number->select the
column->Fixed to select decimal place 2 and then change it.
Hope this helps you.
Regards,
Anand
Hi mrkachhia,
You need to write some thing like this in your script.
Customer Name
Customer ID
Customer Order Number
Customer Part Number
Order Quantity
Order Price
(Order Quantity * Order Price) as CustomerOrderTotal
Supplier ID
Supplier Part Number
Supplier Price
(Order Quantity * Supplier Price) as SupplierOrderTotal
As i understand it am i right or wrong please confirm.
Regards,
Anand
I have done this but not able to fixed value of these two columns to 2 decimal...
Go to settings, document properties, numbers.
Select the fields you want fixed and change the number settings.
Hi,
You need to set its decimal place by change the setting of this column. Just go to Properties->Number->select the
column->Fixed to select decimal place 2 and then change it.
Hope this helps you.
Regards,
Anand
Thanks to both of you....its working, can i get total of all line at bottom or top for both of these columns?
Hi,
Yes you need to select the Straight Table go to Presentation-> and select Totals on first row.
Regards,
Anand
total on first row works only for EXPRESSIONs and not for DIMENSIONs.
Am i RIGHT?
Hi,
Yes you right it works only for Expressions.
Anand
OK THANKS....