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 help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes