Cedia, yes, absolutely you can do this! But....
Any time you run something through a calculated field (in 7.0.1 or before) then the number formatting is completely lost. So you will need to preform contortions to get the numbers to display correctly. Here's what I had to do:
Needless to say, I wish there was a better way. But this will get you there....
Thanks for the help. I'm still having issues though. when I use that formula it returns an error "Cannot use 'Null' type in 'Case' Function" Is the "RAWSQL_STR" available in 7.0? Or is my function just set up wrong.
When 'Percentage of Production' then RAWSQL_STR("Format(%1,'Percent')",[Section_Calc])