Expression Error

[asknyldz]

Hi there,

My Expression is,

=(sum({<TYPE={'ACTUAL'},[BUSINESS]={'New','Expanded'}>-<CLIENT={'NEW CLIENTS','EXPANDED CLIENTS','FORECAST ADJUSTMENT'}>}AMOUNT))/1000

Thats mean, Business should be New and Expanded.

I Click Renewal, why i see New and Expanded.figures in my data?

Thanks

[markodonovan]

Hi Askin,

Could you upload the sheet or show the current selections ?

I assumed they are the same field.

Mark

[Nicole-Smith · Accepted solution]

It's because in the set analysis you're telling it to only look at New and Expanded.  If you want it to take into account your selections, you can use the P() function with it:

=(sum({<TYPE={'ACTUAL'},[BUSINESS]={'New','Expanded'}*P([BUSINESS])>-<CLIENT={'NEW CLIENTS','EXPANDED CLIENTS','FORECAST ADJUSTMENT'}>}AMOUNT))/1000

[asknyldz]

Dear Nicole,

Thats perfect solution is P()

Regards,

Askin