Skip to main content

Hello Pigment Community,

I need help with automating calculations for specific brands in Pigment.

  • Requirement:

    • For the brands marked (e.g., checked/true), I want Pigment to automatically calculate the values.
    • For the unmarked brands (e.g., unchecked/false), I want to manually input the data.

    •  

  • Goal:

    • I would like to filter the view to display only the unmarked brands (those marked as false), so I can easily input data manually.

    •  

Thank you for your help.

Hi ​@Spandan98, what I usually do when I need to treat blank as false so I can properly filter for it, is using EXCLUDE of all true values. You could create a new metric FLTR Brands w/o switch Price and add the formula TRUETADD CONSTANT: Brand]aEXCLUDE: INP_switch_Price]. This should give you TRUE for all combinations except where your switch price metric is true. Then, to filter for those brands in a View, you will need to create a table, add your INP_ForecastPrice_Manual to it as well as your new FLTR metric. In the View, add a filter to keep only brands where that FLTR metric is TRUE and then hide the FLTR metric.

Reply


Ask your question here!

Terms & ConditionsCookie settings