topic Re: Need Help In Expression in App Development

Need Help In Expression

kakaderanjit53 — Fri, 02 Jun 2017 14:49:10 GMT

Dear Expert,

I have Following Inline Table

Test:

Load * Inline [

Type,Sp,ExchangeCoe,Month

P,100,NSE,Jan

SP,200,BSE,Jan

P,300,BSE,Feb

SP,500,NSE,Feb

SP,600,BSE,Mar

];

after adding fields into table it showing like Sample.png

Please Find Actual and Expected images.

Here My Requirement is when i click on Type SP it is showing sales 500,200,600

like that if i click on Type P i want to show 300,100,600

Note: if i click on Type P i want to Show 300,100 for Feb,Jan and

For March Month i want show 600

logic is if i click on Type P want to show sales 300,100, for March Month There is no Type P in this Case i want Show SP Sales As P Sales

Please Kindly Help Me

Thanks,

K.Ranjit.

sunny_talwar — Fri, 02 Jun 2017 15:02:42 GMT

Try this

Sum({$+<Month = {"=Count({<Type>}DISTINCT If(Type = 'P', Type)) = 0"}, Type = {'SP'}>} Sp)

kakaderanjit53 — Fri, 02 Jun 2017 15:29:35 GMT

Dear Sunny,

Its Working Well,Thanks A lot For Your Help

Could Please Explain the Expression.

Once Again thank you So much.

kakaderanjit53 — Fri, 02 Jun 2017 15:42:08 GMT

hi Sunny,

Could you Please Explain Above Expression.

it will more helpful to me.

Thanks,

K.Ranjit.