variable help

hopkinsc — Thu, 06 Dec 2012 11:06:48 GMT

Hi Everyone,

I have the foloowing variable..

LET vTargetSum_DistributionChart =

'avg({1<

[it_target_type]={"Distribution"},

it_objective_name={'&CHR(36)&'(v_it_objective_name_selections)},

territory_region={'&CHR(36)&'(v_territory_region_selections)},

JOIN_territory={'&CHR(36)&'(v_JOIN_territory_selections)}

[it_target_value]

)';

I want to add in some logic but un sure on how to do it.

basically if the result of the above is NULL then i want to show it as 0.

Can anyone help on how to incorporate this into the above variable please?

Thanks

Re: variable help

Gysbert_Wassenaar — Thu, 06 Dec 2012 11:22:04 GMT

Try using the alt function: