Struggling with custom report math and number format

I need to add formatting to this expression;

[=(TN('{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True) && (OS.GStatus= ) AND (DE=Gofood)}')-TN('{REPORT TICKET DETAILS:[CA.#PastiAdaPromo.sum]*[0.75]*[CA.#PastiAdaPromo.sum]/[60000]}'))*0.2]

The above returns correct number but without formatting.
Wrapping with F() doesnt want to work and returns blank. Need 1000’s seperator.

Any suggestions appreciated.

never mind, got there in the end;

[=F((TN('{REPORT ORDER DETAILS:O.ExactTotal.Sum:(ODI=True) && (OS.GStatus= ) AND (DE=Gofood)}')-TN('{REPORT TICKET DETAILS:[CA.#PastiAdaPromo.sum]*[0.75]*[CA.#PastiAdaPromo.sum]/[60000]}'))*0.2)]

3 Likes