Dual expression returns "error: error in expression: ')' expected. What am I missing?

[#1]

I have this expression that I am trying to format as a % with 2 decimal points. I can't seem to figure out what I am missing. Any assistance is appreciated.

=fabs(sum({<ItemCategory={'Individual Reprints','Individual Deluxe Reprints'}>}ITEM_COUNT))/(fabs(sum({<ItemCategory={'Individual Original Manuscripts'}>}ITEM_COUNT)'##.##%'))

[#2]

You missed the num() function. You can try this:

=num(((fabs(sum({<ItemCategory={'Individual Reprints','Individual Deluxe Reprints'}>}ITEM_COUNT)))/

(fabs(sum({<ItemCategory={'Individual Original Manuscripts'}>}ITEM_COUNT)))),'##.##%')

[Nicole-Smith · Accepted solution]

=num(fabs(sum({<ItemCategory={'Individual Reprints','Individual Deluxe Reprints'}>}ITEM_COUNT))/(fabs(sum({<ItemCategory={'Individual Original Manuscripts'}>}ITEM_COUNT))),'##.##%')

[PrashantSangle]

Hi,

Try this,

=num(fabs(sum({<ItemCategory={'Individual Reprints','Individual Deluxe Reprints'}>}ITEM_COUNT))/fabs(sum({<ItemCategory={'Individual Original Manuscripts'}>}ITEM_COUNT)),'##.##%')