Hello there Gurus of the Crystal World
I've got this challenge for you people:
I've created a formula field based on another field;
the formula field is a "Select/case formula" where I lookup onto a gl field and I've assigned a $value according with the gl field.
What I would like to do is once I've got the result I need to do a sum from this formula with the running total of that gl field...eg 'gl-field' + 'formula($value)'
I've got an error saying that is not a numerical field...
Please help....I've tried "tonumber('formula-$111.11')" but still comes up with an error
HELP!!!
I've got this challenge for you people:
I've created a formula field based on another field;
the formula field is a "Select/case formula" where I lookup onto a gl field and I've assigned a $value according with the gl field.
What I would like to do is once I've got the result I need to do a sum from this formula with the running total of that gl field...eg 'gl-field' + 'formula($value)'
I've got an error saying that is not a numerical field...
Please help....I've tried "tonumber('formula-$111.11')" but still comes up with an error
HELP!!!