Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this formula:
(sum( {$<FieldA = {'1'}>} FieldB))
I would like to replace the {'1'} with a variable but can't seem to get the syntax correct. Can someone help me with this?
=sum( {$<FieldA = {'$(variable)'}>} FieldB)
This should do. If it is not working, you should analyze how the variable has been declared.
Regards Eddie
=sum( {$<FieldA = {'$(variable)'}>} FieldB)
This should do. If it is not working, you should analyze how the variable has been declared.
Regards Eddie
Thanks Eddie, that worked. I am still trying to learn the exact syntax for some of these equations when and where to use them. Thanks for the quick response.
Charles