Very New. I can't understand what's wrong with my beast mode formula.

Options
abgstv
abgstv Member
in Beast Mode

I'm trying to get the difference between how many impressions are projected to be served vs how many have served.

All the individual parts work fine but combined there is an issue I can't make sense of.
Is there something obviously wrong with my syntax?

Impressions is how many impressions served up to the previous day
Budget is total number of impressions expected.


I

(SUM(Impressions) /
(
(Budget / DATEDIFF(End Date, Start Date))

  • DATEDIFF(CURDATE(), Start Date)
    )) * 100

The way I do this in excel is to break apart each calculation into it's own column since I'm way out of my wheel house but domo doesn't let you stack calculated columns.

Answers

  • DavidChurchman
    DavidChurchman Coach

    I count 6 of these: (

    and 7 of these: )

    If that's not it, then can you give more details about what's not working? Is the formula validating, but not giving the expected result? Or is it not validating at all?

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

  • ArborRose
    ArborRose Coach

    Besides the parens, I see a dot where I should see a asterisk.

    (SUM(Impressions) /
    
(Budget / DATEDIFF(`End Date`, `Start Date`) * DATEDIFF(CURDATE(), `Start Date`))
    
) * 100


    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • abgstv
    abgstv Member

    I able to fix this, but thanks everyone for chiming in.
    Outside of the few fixes to the syntax my incoming data was bad.

Categories