How to pass parameter to variable/function which include multiple comma .

[vaibhavb]

Here, p_NumberFormatter  is varaible/function for amount formatting which accepts only single input as $1 and

p_sumOne and p_sumTwo is parameter.

Explained below :- 

p_NumberFormatter : Money($1/CONVERSIONFACTOR, $(=chr(39) & CURRENCYFORMAT & chr(39)))

p_sumOne : Sum(DAYSCLOSINGBALANCE)

p_sumTwo : Sum({$<GENERALLEDGERTYPEDTL = {'OPR'},GENERALLEDGERLEVEL1={2},GENERALLEDGERLEVEL2 = {3}, CONSIDERTRANSACTION = {'YES'}>}DAYSCLOSINGBALANCE)

$(p_NumberFormatter($(p_sumOne))) -- Working Fine with p_NumberFormatter

$(p_NumberFormatter($(p_sumTwo)) -- Not Working because expression contains one or more ',' (comma).

$(p_NumberFormatter($(=$(p_sumTwo))) -- Working but getting same value in the trend for each fiscal year.

[Brett_Bleess]

Doubt you are going to get any responses without an example QVW file on this one so folks can see exactly what you are doing and how.

Regards,
Brett