Trying to use a formula to choose a value to use in a calc

Question

I am trying to choose between 2 values to use based on a value in another module and lookup to a Cohort from a month value.

So, either the Extrapolated Blank Tariff CoS if the Cohort has Flash ticked in Month End Attributes, or Blank Tariff CoS if the Cohort does not have Flash ticked in Month End Attributes.

This formula will be in the line item 'Blank Tariff CoS used in calcs'

Mapping from Month to Cohort:

kmht0307 · Answer

I have worked out how to do this now, so all solved.

kmht0307 · Answer

@pyrypeura Yes the cohort dimension is available in the Month End Attributes module, so I know that Flash is only ticked for 202602.

pyrypeura · Answer

Hi, Do you have cohort dimension available for Month End Attributes? If you do not have cohort dimension for month end attributes how do you know if flash is ticked for other months than current month?