topic Re: FABS not Working in Text Object in Archived Groups

FABS not Working in Text Object

rustyfishbones — Tue, 22 Jul 2025 17:59:49 GMT

Hi All,

I can use FABS function in a straight table, however when I use it in a text object it does not return the correct result.

FABS(SUM({<TaskId = {'*ADJUST*'}>}[#Act-Second]))

Any ideas why it aint correct in the text object but its ok in the table, should I be removing the null values.

Regards

Alan

sunny_talwar — Tue, 15 May 2018 12:17:25 GMT

May be try this

Sum({<TaskId = {'*ADJUST*'}>} Fabs([#Act-Second]))

or this

Sum(Aggr(fabs(Sum({<TaskId = {'*ADJUST*'}>} [#Act-Second])), ChartDimensions))

rustyfishbones — Tue, 15 May 2018 12:18:53 GMT

ok, this works, but I need a better way

=FABS(SUM({<TaskId = {'*ADJUST*'}, [#Act-Second] = {">0"}>}[#Act-Second]))

+ FABS(SUM({<TaskId = {'*ADJUST*'}, [#Act-Second] = {"<0"}>}[#Act-Second]))

rustyfishbones — Tue, 15 May 2018 12:21:41 GMT

First one worked thanks

msvanfeldt — Tue, 15 May 2018 12:50:35 GMT

I think the problem is the single quotes in the set expression.
Single quotes means exact value. Use double quotes to make a search.

FABS(SUM({<TaskId = {"*ADJUST*"}>}[#Act-Second]))