Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to get the values of Amount when
Amount>0 and Domain='RR' and Type in ('old',New') and ID=56432
here Amount,Domain,Type are from Sales table where ID is from Account table.
could anyone help me please how to write expression to get Amount.
Thanks.
IF(SUM({<Domain = {‘RR’}>}, Type = {<’old’,’New’>, ID = {‘56432’}}Amount)>0, SUM({<Domain = {‘RR’}>}, Type = {<’old’,’New’>, ID = {‘56432’}}Amount))
Considering that there is a common filed between both table. may be ID or Account ID
Thanks and when I am usin this it is showing error at
Type = {<’old’,’New’>,
is there anything I need to change?
IF(SUM({<Domain = {‘RR’}, Type = {’old’,’New’}, ID = {‘56432’}>}Amount)>0, SUM({<Domain = {‘RR’}, Type = {’old’,’New’}, ID = {‘56432’}>}Amount))
Thanks and still it is showing same error in the same place please help as I stucked here.
what is your dimension? Can you upload sample data?
Hi Amelia,
You could also try SUM({<Amount = {">0"}, Domain = {"RR"}, Type = {"old","New"}, ID = {"56432"}>}Amount)
the dimension is employee from Account table
Thanks and hoe can I change if want to get Amount instaed of Sum(Amount) with same requirements.
Please could you send me the expression.
This should work...!!!
IF(SUM({<Domain = {‘RR’}, Type = {’old’,’New’}, ID = {‘56432’}>}Amount)>0, SUM({<Domain = {‘RR’}, Type = {’old’,’New’}, ID = {‘56432’}>}Amount))