Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Askin,
Could you upload the sheet or show the current selections ?
I assumed they are the same field.
Mark
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
Dear Nicole,
Thats perfect solution is P()
Regards,
Askin