Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Divide / multiply by a fixed figure

My customer has a monthly figure 300000 and it needs to be divided by a coloumn which shows how many working days are in that month. Literally 300000 / working days in a month = Daily whatevers   ...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous i didn't understood your question. it should not be very hard. can you share sample data and what you want to achieve as the final result.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Literally

     

    300000 / Workingdays = 

     

    WorkingDays = CALCULATE(sum('date'[IfWorkDay]))

     

    I can't seem to find a way to do this as it wants to reference a field. 30000 doesn't exist in a field it's a static figure.

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      7 years ago

      Anonymous assuming your workingdays formula is correct:

       

      you can do this:

       

      WorkingDays = 
VAR workingDays= CALCULATE(sum('date'[IfWorkDay]))
VAR fixedValue = 30000
RETURN
DIVIDE( fixedValue, WorkingDays)

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        For some reason this is multiplying not dividing?

         

        I've taken the variable: fixedvalue to 1 and it multiplies itself by the amount of working days. (Working days are showing correctly).