Formula Question

[#1]

I am having issue with a formula not returning the expected value.

Here is my formula:

=if(Status <> 'Discarded', (sum({<Scenario={"2015 LBE"}>}(Amount * Division_Rate)/1000)),0).

The returned value is not excluding the 'Discarded' values from the sum.

[sunny_talwar · Accepted solution]

Try if this works:

Sum({<Scenario = {'2015 LBE'}, Status = e({<Status = {'Discarded'}>})>} (Amount * Divison_Rate)/1000)

Best,

S

[#3]

Hi Scott

Please check this formula.

sum({$<Senario={'2015LBE'}>-<Status={'Discarded'}>}Amount*Divison_Rate)/1000.

Regards

Harshana

[renjithpl]

Try this

=if(Status <> 'Discarded', (sum({<Scenario={'2015 LBE'}>}(Amount *Divison_Rate)/1000)), 0)

[PrashantSangle]

Hi,

Try like

sum({<Scenario={"2015 LBE"},Status -={"Discarded"}>}(Amount * Division_Rate)/1000)

It will give you red error line after -= but it will work for you

Regards

[jagan]

Hi,

Try like this

=sum({<Scenario={"2015 LBE"}, Status -={'Discarded'}>}(Amount * Division_Rate)/1000)

Note: Qlikview will show the above expression as error but it works.

Regards,

Jagan.

[#7]

Thank you everyone this worked.