topic Re: Front end expression Help in App Development

Front end expression Help

kiranpatil123 — Sat, 16 Nov 2024 18:56:20 GMT

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

Re: Front end expression Help

sunny_talwar — Mon, 16 Mar 2020 12:29:52 GMT

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)

Re: Front end expression Help

kiranpatil123 — Mon, 16 Mar 2020 13:40:49 GMT

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 .

Re: Front end expression Help

sunny_talwar — Mon, 16 Mar 2020 13:53:00 GMT

Just by looking at the screenshots... no idea