Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)'##.##%'))
=num(fabs(sum({<ItemCategory={'Individual Reprints','Individual Deluxe Reprints'}>}ITEM_COUNT))/(fabs(sum({<ItemCategory={'Individual Original Manuscripts'}>}ITEM_COUNT))),'##.##%')
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)))),'##.##%')
=num(fabs(sum({<ItemCategory={'Individual Reprints','Individual Deluxe Reprints'}>}ITEM_COUNT))/(fabs(sum({<ItemCategory={'Individual Original Manuscripts'}>}ITEM_COUNT))),'##.##%')
Hi,
Try this,
=num(fabs(sum({<ItemCategory={'Individual Reprints','Individual Deluxe Reprints'}>}ITEM_COUNT))/fabs(sum({<ItemCategory={'Individual Original Manuscripts'}>}ITEM_COUNT)),'##.##%')