Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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