If Formula

[#1]

Hi All,

Can someone please tell me what's wrong with the formula stated below. It provides me with the title since I have checked use expression as title but the content is empty nor does it provide me with an error which indicates there's nothing wrong with the expression.

=if (sum({1 <monthofalltime = {$(=vmonthnum-1)}>} TOTAL <d1cust_clientid> $(=filtered_mrv)) = 0 and sum(TOTAL <d1cust_clientid> $(=filtered_mrv)) <> 0, 'new revenue')

Thanks,

[sunny_talwar]

Is new revenue a field here?

May be this:

=If(Sum({1 <monthofalltime = {$(=vmonthnum-1)}>} TOTAL <d1cust_clientid> $(=filtered_mrv)) = 0 and Sum(TOTAL <d1cust_clientid> $(=filtered_mrv)) <> 0, [new revenue])

[#3]

New revenue is not a field at all it is a way to describe if we had a new customer in the month of business. It doesn't work such as =if(A2=B2,"New", "Old") New and Old both her descriptors like was New revenue.

[Anonymous]

Would recommend a sanity check of the 2 sum aggregation code that looks to be making use of variable comparison inside the set expression. A quick observation, it seems else is not handled? what if you add a comma after 'new revenue'

[sangeethag · Accepted solution]

Hi

May be your set analysis part have mistake. Try this,

Change your exp monthofalltime = {$(=vmonthnum-1)} to monthofalltime = {$(=$(=vmonthnum)-1)}

[sasikanth]

hi,

can you tell us about this  "filtered_mrv"

[#7]

Thanks for all of your responses.