Multiple Condition in Set Analysis

[#1]

Dear all,

I have a set of data similar to the following one.

I want to show the data above in a straight table. I have 2 variable, vFromDate and vToDate to control the range of creation date that will be shown in the table. Also, I want to disregard the effect current selection of Folder ID on the straight table. Finally, I want to show data with owner=o or viewer=v or administrator=a only.

I tried the following expression but it is not working as what i expected

sum({<[Folder ID]=,[Creation Date]={'>=$(=Date(vFromDate, 'YYYY-MM-DD'))<=$(=Date(vToDate, 'YYYY-MM-DD'))'}>*<Adminsitrator={'A'}+ Owner={'O'}+Viewer={'V'}>}[Size])

Would you please help? Thanks a lot.

[jaimeaguilar]

Hi,

I think the second part of your expression is what giving you trouble:

sum({<[Folder ID]=,[Creation Date]={'>=$(=Date(vFromDate, 'YYYY-MM-DD'))<=$(=Date(vToDate, 'YYYY-MM-DD'))'}>*<Adminsitrator={'A'}+ Owner={'O'}+Viewer={'V'}>}[Size])

Try rewriting it as follows:

sum({<[Folder ID]=,[Creation Date]={'>=$(=Date(vFromDate, 'YYYY-MM-DD'))<=$(=Date(vToDate, 'YYYY-MM-DD'))'}>*<Adminsitrator={'A'}, Owner={'O'}, Viewer={'V'}>}[Size])

regards

[#3]

Thanks for your advice.I tried it but it is still not working.

[jagan]

Hi,

Can you attach sample file?

Regards,

Jagan.