TC1199A Member

@MichelleH it is working now. Thank you for your help!

@MichelleH I am still having trouble getting it to calculate what I am looking for. Using the formula SUM(SUM(Volume)) FIXED (BY Customer Name) it is still just summing up every fixed value for each row in January.

@MichelleH I have a dataset with the live data and a dataset with the projected data. I am using an SQL to join the two together. The monthly projected value gets assigned to each row of the live data when all constraints are met. This is why I am having to use the distinct function.

@MichelleH I am using a beast mode. The beast mode I am using is SUM(DISTINCT Volume). I am using this formula because I need to know the projected volume for each customer for every month. Is there a way to modify this formula so that it counts each distinct volume for every customer even if they have the same projected…

@Godiepi It looks like it is working now. However, I want to also include the rest of my columns from my input dataset and not just the ones from the two groupings. How should I go about adding these back in?

@Godiepi Once I have my second Group by tile i should use a join correct?

@ColemenWilson I will give this a try. would you recommend this for all text replacement? I have some other fields where i am seeing the same issue.

@ColemenWilson is there a specific place within my recursive Dataflow I should be appending the 2020 data? currently I am adding the excel file with the 2020 data to the append tile in my recursive dataflow just before the final output.

Hey @pauljames, Mainly to clean up the dataflow.

@GrantSmith For example: If I have different unique PO's in one column and a column that tells me how many days the PO has before its ship date. Will this alert be able to go through the column for days and alert me with what PO's have less than 5 days before the ship date?

@trafalger ^

Thanks for the response! Do you know what kind of cards allow non-summary number alerts?