Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to convert the negative numbers to positive like this: -1356 to (1356) and the positive numbers should become empty cells with a – See attachment for an example. (always good to make something negative positive :))
@Kirsten may be
=if(Field>0,null(),-Field)
Hi @Taoufiq_Zarra thanks.
My expression currently looks like this:
((1-Sum([Sum of Total Sum of Hours [ITM]]])/Sum([Count of EQ ID])/3.1)*Sum([Sum of Total Sum of Cost [ITM]]]))*-1
With the *-1 I made the negatives positive.
How do I need to integrate your code in this?
With @Taoufiq_Zarra solution.
If(((1-Sum([Sum of Total Sum of Hours [ITM]]])/Sum([Count of EQ ID])/3.1)*Sum([Sum of Total Sum of Cost [ITM]]]))<0,
-((1-Sum([Sum of Total Sum of Hours [ITM]]])/Sum([Count of EQ ID])/3.1)*Sum([Sum of Total Sum of Cost [ITM]]]))
)