Hi Guys,
I have added a consternated field (Currency + Price) on to item list page as a text field and this is left aligned and shows like below:
Currency and Price
$10.5
Is there a way to programmatically change the alignment to below:
Currency and Price
$10.5
Thanks
You can set the AutoFormatExpression to a function call as well ... AutoFormatExpression = GetFormatString();
and then add code to return the relevant currency string
procedure GetFormatString() : Text
Begin
CASE "Currency Code your Working in" OF
'USD' : Exit('1,USD');
'GBP' : Exit('1,GBP');
//. . . . .
END;
end;
you can also use AutoFormatType 11 and come up with you own formatting in the AutoFormatExpression (i.e. 'Golden Galleons <Precision,5:5><Standard Format,0>'
This can work if we are looking at one currency but the price is defined in different currencies hence I'm concatenating two fields and autoformat needs a non text field. May be pass currency as a variable or something like that to Autoformat formula
User the AutoFormat properties on the page...
AutoFormatExpression = '1,USD';
AutoFormatType = 10;
The result is right aligned
Sohail Ahmed
1,169
YUN ZHU
1,006
Super User 2025 Season 1
Mansi Soni
830