CSI Dataview expression columns and expression summaries questions

Legacy Contributor

Hello,

I created an expression column using the expression:  DATAVIEWPROP( SLItems_DerCurUCost ) * DATAVIEWPROP( QtyOnHand )

For some reason the column is formatted as text.  How can I convert it to numbers so that it is right justified and exported to excel as numbers?

Also what would an expression summary that sums this column look like?

I checked Infor's documentation but it is lacking on this topic.

Thanks in advance.

Legacy Contributor

I believe you are looking for:

DATAVIEWPROP( DerCurUCost ) * DATAVIEWPROP( DerQtyOnHand )

To have it formatted as a decimal, you choose the decimal data type when you add the expression column.

As for the summary, it depends on how you want it displayed. It can be as easy as clicking Show Summaries the Display menu, clicking the E button next to the column name, and checking Sum for the aggregate options. That will show the sum in the Grand Summaries bar at the bottom of the data view for the column.

The other way is to use an Expression Summary with a formula of:

SUMEXP( 'SLItems', DATAVIEWPROP( DerCurUCost ) * DATAVIEWPROP( DerQtyOnHand ) )

Which gives you the same result, though the first way is cleaner.