Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jciamaichela
New Contributor

Not to Exceed issue

I am Trying to create a Work in Progress Backlog report using WIP Accounting practices. Where I am getting stuck is the not to exceed portion. I have a table that reflects the following fields. Estimated Reveue, Total Job Cost, and Recognized Revenue

Estimated Revenue is the amount we believe we are going to be paid for the job

Total Job Cost is the amount currently Spent in Cost on the job

Recognized Revenue is (Total Job Cost / 0.40 (Target Profit Margin))

I need help with the formula to make sure (Recognized Revenue does not exceed Estimated Revenue)

1 Solution

Accepted Solutions

Re: Not to Exceed issue

Perhaps rangemin([Recognized Revenue], [Estimated Revenue])


talk is cheap, supply exceeds demand
2 Replies

Re: Not to Exceed issue

Perhaps rangemin([Recognized Revenue], [Estimated Revenue])


talk is cheap, supply exceeds demand
jciamaichela
New Contributor

Re: Not to Exceed issue

That worked Thank you.

Community Browser