2.03 Special DisplayFormat

Q1 : How if data is Zero(0) and I wanted to be printed as - and some space on the back?

A : Just Enter as Follow code:-

[FormatFloat(',0.00;-,0.00;- ',<Main."Amount">)]

Q2 : How to set a given string as this 123456121234 to show as 123456-12-1234?

A : Just Enter as Follow code:-

[FormatMaskText('000000-00-0000;0;',<Employee."NewIC">)]

Q3 : How to set displayformat follow the option for Grand Total?

A : Just Enter as Follow code:-

[FormatFloat(<Option."StockQuantityDisplayFormat">, SUM(<Main."TotalQty">,MasterData1))]

OR

[FormatFloat(<Option."AccountingValueDisplayFormat">, SUM(<Main."TotalAmt">,MasterData1))]

Q4 : How to set displayformat BlankWhenZero or Hide Zeros if using FormatFloat function?

A : Just set the display format at Tools | Options | Misc to #,0.00;-#,0.00; ;

OR

A : Just Enter as Follow code :-

[IIF(SimpleRoundTo(<Document_Detail."Qty">*<Document_Detail."UnitPrice">,-2) <> 0,

FormatFloat(<Option."AccountingValueDisplayFormat">,

SimpleRoundTo(<Document_Detail."Qty">*<Document_Detail."UnitPrice">,-2)), '')]