Skip to Content
-1
Jun 07, 2018 at 06:38 PM

Append % to field in the formula in CDS view

1564 Views

Hallo Experts,

The below is the formula which gives % value in Query CDS view

@AnalyticsDetails.query.formula: '(NDIV0( (xxx - ( yyy + zzz ) ) / xxx )*100)' @EndUserText.label: 'Gross Profit Margin %'

1 as GrossPrMargin,

The value is displayed as 110111.00

Expected value should be 110111.00%

The % symbol should be appended at the end

I tried concatenating in the formula it did not work

Any solutions Please let me know


Thanks