Hello,
Cognos Reportnet newbie here. Could you please tell me the best approach for this problem? I've created three singletons on a report. Each singleton totals an ID field from three separate queries with their own query subjects and filters. Now I need to subtract the values of the first two singletons from the third. Would this be done as a data item expression in a new query? If so, what would the syntax be? Or am I going about this all wrong, which wouldn't surprise me!
Thanks for your help.
Cognos Reportnet newbie here. Could you please tell me the best approach for this problem? I've created three singletons on a report. Each singleton totals an ID field from three separate queries with their own query subjects and filters. Now I need to subtract the values of the first two singletons from the third. Would this be done as a data item expression in a new query? If so, what would the syntax be? Or am I going about this all wrong, which wouldn't surprise me!
Thanks for your help.