Front end expression Help

[kiranpatil123]

Hi all ,

PFA excel . i have 3 columns - Quarter(A) , Per(B) and ISP(C) ( PFA excel ) 

I need sum of column ISP (C) where column B(Per) and Column (ISP ) is greater than 0.

How do i do that in both FRONTEND and BACKEND please help .

I tried in front end with this but its not working . Please help

=sum({<ISP={"=RangeSum(Per,ISP)>0"}>}ISP)

Value should be - 2764339

Advance thanks

[sunny_talwar · Accepted solution]

May be try this expression

=Sum({<ISP = {">0"}>*<Per = {">0"}>}ISP)

If you want to do this in script... you can create a flag in the script

Table:
LOAD Quarter, 
     Per, 
     ISP,
     If(Per > 0 and ISP > 0, 1, 0) as Flag
FROM
[C:\Users\talwars\Downloads\DaTA.xlsx]
(ooxml, embedded labels, table is Sheet1);

and then use this expression

=Sum({<Flag = {'1'}>}ISP)

[kiranpatil123]

Thanks Sunny 
its working fine for the example which i provided 

But in my dashboard I'm getting zero .. any idea Y ?

I have attached the screen shot .

[sunny_talwar]

Just by looking at the screenshots... no idea