Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

if to set analysis

Hello,

i wont to convert this expression :

if(dim_a='yes' or dim_b='yes', sum(CA))

to set analysis

best regards

7 Replies
MK_QSL
MVP
MVP

SUM({<dima_a = {'yes'}>}CA) +

SUM({<dima_b = {'yes'}>}CA)

Not applicable
Author

there is no way to do it in the same expression ?

ashfaq_haseeb
Champion III
Champion III

Hi,

Try below

SUM({<dima_a = {'yes'},dima_b = {'yes'}>}CA)


Regards

ASHFAQ

Not applicable
Author

=Sum({<dim_a={'A'}>+<dim_b={'B'}>} CA)

its_anandrjs

Write like


Sum( {<dim_a = {'yes'}, dim_b = {'yes'}>}  CA)

Not applicable
Author

SUM({<dima_a = {'yes'}>}CA)  + SUM({<dima_b = {'yes'}>}CA)

VishalWaghole
Specialist II
Specialist II

Sum({<dim_a = {'yes'}> + <dim_b = {'yes'}>} CA)