Guage settings

[#1]

Please could someone assist me with guage settings.

I have included an example.

I would like to see the full amount when I hover over the dial, not the rounded amount.

Also would it be possible to have a moving target for the budget

eg.  Budget each month is £5833.

If my expression sums one month then let it be red after 5833

If my expression sums two months then let it be red after 11666 etc.

Very grateful for all assistance.

[Gysbert_Wassenaar]

See attached qvw. I don't understand your second question. Your expression sums all months, which are all separate fields.

[#3]

Thank for your assistance with point one Gysbert.  Please could you explain the expression to me. It is giving the answer I need.

With regards to the budget, I mean, if I were to select Jan and Feb and March, I would want the calculations to work for those month only for the sum and where the red starts.

[Gysbert_Wassenaar]

About the dual function... see Dual & Exists – Useful Functions ‌and How to use- Dual().

You can't select Jan, Feb and March. They're field names, not field values. You can select 5833 and/or 0 in the field Jan. In the field Feb you can select 2010 and/or 5833. In the field March you select 3005 and/or 5833.