Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try if this works:
Sum({<Scenario = {'2015 LBE'}, Status = e({<Status = {'Discarded'}>})>} (Amount * Divison_Rate)/1000)
Best,
S
Try if this works:
Sum({<Scenario = {'2015 LBE'}, Status = e({<Status = {'Discarded'}>})>} (Amount * Divison_Rate)/1000)
Best,
S
Hi Scott
Please check this formula.
sum({$<Senario={'2015LBE'}>-<Status={'Discarded'}>}Amount*Divison_Rate)/1000.
Regards
Harshana
Try this
=if(Status <> 'Discarded', (sum({<Scenario={'2015 LBE'}>}(Amount *Divison_Rate)/1000)), 0)
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
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.
Thank you everyone this worked.