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