How two expressions could be applied in set expression with < along with other dimention!

[nevilledhamsiri]

I need following conditions to be satisfied through a set expression

Dimensions

PRD_CODE

BRANCH

EXPRESSIONS

GROSS PREMIUM

NET PREMIUM

I wrote the set expression as follows!

SUM({<PRD_CODE={'KK','PP'},BRANCH={'RA'}, GROSS PREMIUM={">NET PREMIUM"}>} SALES)

I require when PRD_CODE=kk,pp, and Branch = RA, GROSS PREMIUM > NET PREMIUM, the sales!

Please see the error & the place

Thanks for early reply

Neville

[Anil_Babu_Samineni · Accepted solution]

I always prefer to create in script like

If(gross>net, 1,0) as flag then in Set analysis you can write flag ={1}

Or else try this

SUM({<PRD_CODE={'KK','PP'},BRANCH={'RA'}, GROSS PREMIUM={"= GROSSPREMIUM >NET PREMIUM"}>} SALES)

[lironbaram]

hi

because set analysis is like making selection in the app

your last condition isn't going to work

you'll need something like

SUM({<PRD_CODE={'KK','PP'},BRANCH={'RA'}>} if(GROSS PREMIUM>NET PREMIUM,SALES))

this expressions assumes that gross premium and net premium are values in a record and not aggregation functions