Expand my Community achievements bar.

Wondering how Workfront Proof works? Join our AMA on May 8th and ask our Community experts!

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Help with a calculation field?

Avatar

Level 2

Hi! I am trying to do a calculation field based off hour types. Basically, if the hour type was entered before a certain date, calculate multiplying by 60. If it was after, multiply by 55. I have looked at this thing so much and nothing seems to make it work. Any suggestions? At this point, I think I have it butchered...

IF({entryDate}<2021-01-15, (CEIL({hours}*2)/2)*55, IF({hourType}.{name}="Internal Transfer (No Changes)", (CEIL({hours}*2)/2)*55, IF({hourType}.{countAsRevenue}=1, (CEIL({hours}*2)/2)*55, 0)))),IF({hourType}.{name}="Correction Other", (CEIL({hours}*2)/2)*60, IF({hourType}.{name}="Internal Transfer (No Changes)", (CEIL({hours}*2)/2)*60, IF({hourType}.{countAsRevenue}=1, (CEIL({hours}*2)/2)*60, 0))))

aggregator.displayformat=double

aggregator.function=SUM

aggregator.valueexpression=IF({entryDate}<2021-01-15,IF({hourType}.{name}="Correction Other", (CEIL({hours}*2)/2)*55, IF({hourType}.{name}="Internal Transfer (No Changes)", (CEIL({hours}*2)/2)*55, IF({hourType}.{countAsRevenue}=1, (CEIL({hours}*2)/2)*55, 0))),IF({hourType}.{name}="Correction Other", (CEIL({hours}*2)/2)*60, IF({hourType}.{name}="Internal Transfer (No Changes)", (CEIL({hours}*2)/2)*60, IF({hourType}.{countAsRevenue}=1, (CEIL({hours}*2)/2)*60, 0))))

aggregator.valueformat=doubleAsDouble

displayname=Base Cost

linkedname=direct

namekey=hours

querysort=hours

textmode=true

valueexpression=IF({entryDate}<2021-01-15,IF({hourType}.{name}="Correction Other", (CEIL({hours}*2)/2)*55, IF({hourType}.{name}="Internal Transfer (No Changes)", (CEIL({hours}*2)/2)*55, IF({hourType}.{countAsRevenue}=1, (CEIL({hours}*2)/2)*55, 0))),IF({hourType}.{name}="Correction Other", (CEIL({hours}*2)/2)*60, IF({hourType}.{name}="Internal Transfer (No Changes)", (CEIL({hours}*2)/2)*60, IF({hourType}.{countAsRevenue}=1, (CEIL({hours}*2)/2)*60, 0))))

valueformat=doubleAsDouble

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

0 Replies