Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Come join our upcoming coffee break and ask away!

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