output a variable instead of a number inside a formula

[#1]

Hi, I am looking to make a calculation spit out a variable instead of a number inside a summation formula - for example,

sum(

if(

isnull(ID), Revenue, NullRevenue, Revenue))

Ideally the output should be sum(Revenue) or sum(NullRevenue), but since if(isnull(ID), Revenue, NullRevenue, Revenue) spits out a number it ends up calculating sum(some numerical value). Any idea would be appreciated, thanks!

[danieloberbilli]

you can write a variable like this in the backend

LET vResult = '=sum(if(isnull(ID), Revenue, NullRevenue))';

[MarcoWedel]

if you like to get the strings 'sum(Revenue)' or 'sum(NullRevenue)' then you could try like:

='Sum('&If(IsNull(ID), 'NullRevenue', 'Revenue')&')'

hope this helps

regards

Marco