How to remove columns where sales is 0

[sakshikaul]

Hi

I want to remove those values where MRP daily target(column name is Budget) is 0

so what changes should be made in following expressions?

=num(sum({< Sold_Date = {">=$(From)<=$(To)"} >} Budget),'#,##0.0')

Regards

Sakshi

[Miguel_Angel_Baeyens]

If that Budget is on one field and you need no further aggregation, i.e.: remove the lines for which the line's budget is not zero, you could try

Num(Sum({< Sold_Date = {">=$(From)<=$(To)"}, Budget = {">0"} >} Budget), '#,##0.0')

or

Num(Sum({< Sold_Date = {">=$(From)<=$(To)"}, Budget = {"=Sum(Budget) > 0"} >} Budget), '#,##0.0')

But depends on your datamodel, of course.

EDIT: syntax corrected

[vishsaggi]

You mean you want to supress 0 values where ever your colum MRP Daily Targes are 0.0? I mean hide rows where there are 0's right? IF yes, you have to check Supress 0 values in Presentation tab and write an calculated dimension expr like below:

for SAP Code

= Aggr(IF(sum({< Sold_Date = {">=$(From)<=$(To)"} >} Budget) = 0, 0, SAPCode), SAPCode)

Try this and let us know.

[sakshikaul]

This expression is giving an error and I want to remove all those stores name where value is coming 0 so how to write an expression for that /

Num(Sum({< Sold_Date = {">=$(From)<=$(To)"}, Budget = {"=Sum(Budget) > 0"} >} Budget=, '#,##0.0')

what all changes should be done in the following expression?

[vishsaggi]

Can you share your app if possible? Did you try calculated dimension expression as i mentioned?

[Miguel_Angel_Baeyens]

Yes, there is a missing ")" instead of a "=" after Budget.