How to Format a Formula Field that pulls a Currency from another Formula Field

Question

Need the 'Test Formula' field to format the 'Trip Total:' as currency.  Any ideas anyone?

CottageKeeper · Accepted Answer

Many thanks to @W_Vann_Hall and his demonstration base for Pretty Print - for an answer!

DATETIME_FORMAT({Date of Trip}, 'YYYY-MM-DD')

&"\nTrip Total: "& IF(

LEFT({Sourcing Trip Total}&'',1,1)='-',

'-',

'')&'$'&

IF(

ABS(VALUE({Sourcing Trip Total}&''))>=1000000,

INT(ABS(VALUE({Sourcing Trip Total}&''))/1000000)&','&

IF(

INT(MOD(VALUE({Sourcing Trip Total}&''),1000000)/1000)<100,

REPT('0',3-LEN(INT(MOD(VALUE({Sourcing Trip Total}&''),1000000)/1000)&'')),

'')&INT(MOD(VALUE({Sourcing Trip Total}&''),1000000)/1000)&','&

IF(

INT(MOD(VALUE({Sourcing Trip Total}&''),1000))<100,

REPT('0',3-LEN(INT(MOD(VALUE({Sourcing Trip Total}&''),1000))&'')),

'')&INT(MOD(VALUE({Sourcing Trip Total}&''),1000)),

IF(

ABS(VALUE({Sourcing Trip Total}&''))>=1000,

INT(ABS(VALUE({Sourcing Trip Total}&''))/1000)&','&

IF(

INT(MOD(VALUE({Sourcing Trip Total}&''),1000))<100,

REPT('0',3-LEN(INT(MOD(VALUE({Sourcing Trip Total}&''),1000))&'')),

'')&INT(MOD(VALUE({Sourcing Trip Total}&''),1000)),

INT(ABS(VALUE({Sourcing Trip Total}&'')))))&'.'&

IF(

LEN(ROUND(MOD(VALUE({Sourcing Trip Total}&''),1)*100,0)&'')<2,

'0',

''

)&

ROUND(MOD(VALUE({Sourcing Trip Total}&''),1)*100)

&"\nSales Tax %: "& {Sales Tax %}

Sign up